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

18 votes150 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote143 views1 answer
Mariadb set vertical output format
SQL
0 vote147 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote158 views1 answer
Default value false mysql
SQL
2 votes169 views1 answer
Mysql select default if null
SQL
0 vote173 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote286 views1 answer
Running mysql from bash sc
SQL
1 vote158 views1 answer
Mysql pretty date format
SQL
12 votes159 views4 answers
Mysql version query
SQL
4 votes155 views1 answer
Mysql not equal
SQL