Oracle create chain rule

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 vote214 views1 answer
Mysql show schema
SQL
9 votes177 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote174 views1 answer
Mysql count number of occurrences in a column
SQL
4 votes169 views2 answers
Sql table
SQL
12 votes165 views3 answers
Install sqlite driver ubuntu
SQL
0 vote169 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote220 views1 answer
Drop a view in sqlite
SQL
1 vote179 views1 answer
Display total number of tables in mysql
SQL
0 vote266 views1 answer
Sql to search who modified
SQL
-1 vote185 views2 answers
Installing mysql on centos 7
SQL