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 vote122 views2 answers
Sqlalchemy core in clause
SQL
6 votes128 views2 answers
If not exists insert sql
SQL
53 votes326 views6 answers
How to install mysql ubuntu
SQL
1 vote121 views1 answer
Oracle lock user
SQL
0 vote141 views1 answer
Oracle concat datetime
SQL
2 votes183 views3 answers
Xampp mysql database not starting
SQL
3 votes161 views1 answer
How to add unique constraint in mysql table
SQL
0 vote133 views1 answer
Mysql to get column name in database
SQL
0 vote258 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
1 vote130 views1 answer
ALL_TAB_PARTITIONS
SQL