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 vote136 views1 answer
Oracle list datafiles
SQL
1 vote138 views2 answers
Mysql extract month
SQL
2 votes152 views1 answer
Oracle trace file
SQL
0 vote99 views1 answer
Mariadb list tables
SQL
5 votes167 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
8 votes144 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
1 vote179 views1 answer
Postgresql append array
SQL
1 vote131 views1 answer
Postgresql convert text to float
SQL
4 votes182 views2 answers
Mysql alter table set column unique
SQL
-1 vote134 views8 answers
Create Trigger in phpMyAdmin
SQL