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 vote167 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
9 votes179 views1 answer
Oracle get table schema
SQL
0 vote139 views1 answer
Django how to get query result count
SQL
0 vote219 views1 answer
Redshift running queries
SQL
23 votes183 views2 answers
Query to delete a database in mysql
SQL
1 vote170 views1 answer
Select not matching data from two tables
SQL
1 vote175 views1 answer
Apex select list ORA-20999
SQL
0 vote185 views1 answer
How to check database engine in mysql
SQL
0 vote160 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote196 views2 answers
Sql auto update dupdated_at
SQL