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

1 vote160 views1 answer
How to select random rows from table
SQL
1 vote162 views1 answer
How to install mysql 8.0 windows service
SQL
10 votes163 views4 answers
Primary key in sql
SQL
1 vote165 views1 answer
Oracle sql assign unique number to each grouping
SQL
1 vote212 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote125 views1 answer
Get last run query sql server
SQL
2 votes255 views2 answers
Set value to null sql
SQL
0 vote158 views6 answers
Unique key in sql
SQL
-1 vote219 views3 answers
Error: mysql shutdown unexpectedly.
SQL
-1 vote177 views1 answer
How to reset autoincrement in sqlite java
SQL