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

2 votes125 views1 answer
Sql server conection string
SQL
5 votes92 views1 answer
Alter table default value mysql
SQL
1 vote142 views2 answers
Mysql switch case
SQL
0 vote136 views1 answer
View to table sql
SQL
1 vote88 views1 answer
Mysql show attributes of a table
SQL
0 vote119 views1 answer
Commit transaction sql
SQL
34 votes118 views6 answers
Sql change data type
SQL
0 vote132 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote122 views1 answer
Mysql where in keep order
SQL
0 vote137 views1 answer
Find duplicate users by email address in mysql
SQL