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 vote125 views1 answer
Time mysql w3
SQL
1 vote124 views3 answers
Nth highest salary
SQL
0 vote181 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote117 views1 answer
Sort by last two number sql
SQL
1 vote122 views1 answer
Sql select table header
SQL
0 vote116 views1 answer
Mysql where in keep order
SQL
4 votes152 views6 answers
Select sql
SQL
1 vote153 views1 answer
Oracle drop chain step
SQL
0 vote114 views1 answer
Sql sort ages
SQL
9 votes120 views4 answers
Postgresql export database
SQL