Oracle create chain rule

Oracle chain rules

SELECT OWNER,
       CHAIN_NAME,
       RULE_OWNER,
       RULE_NAME,
       CONDITION,
       ACTION,
       COMMENTS
FROM DBA_SCHEDULER_CHAIN_RULES
ORDER BY OWNER, CHAIN_NAME, RULE_OWNER, RULE_NAME;

Source: oracle-base.com

Oracle create chain rule

BEGIN
    DBMS_SCHEDULER.DEFINE_CHAIN_RULE(
            CHAIN_NAME => 'chain1',
            CONDITION => 'TRUE', -- starting step
            ACTION => 'START step1',
            RULE_NAME => 'chain1_rule1',
            COMMENTS => 'Starting chain');
END;

Source: oracle-world.com

Similar codes

0 vote291 views1 answer
Syntax for changing column size in mysql
SQL
0 vote296 views1 answer
Oracle activate program
SQL
-2 votes296 views1 answer
Group functions in sql
SQL
0 vote310 views2 answers
Faster mysql imports
SQL
1 vote279 views1 answer
Sql group by error
SQL
-1 vote308 views1 answer
How to change the auto increment in existing table mysql
SQL
6 votes285 views4 answers
Sqlite drop table
SQL
0 vote301 views1 answer
Flask sqlalchemy remove duplicates
SQL
7 votes300 views5 answers
Show details of table postgres
SQL
0 vote303 views2 answers
Nosqlbooster query other collection
SQL