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 vote206 views1 answer
Install postgresql on raspberry pi
SQL
1 vote279 views1 answer
Mysql show database size in mb
SQL
0 vote214 views1 answer
SQL Error 1040 : Too many connections
SQL
-1 vote201 views2 answers
How to display top 50 rows?
SQL
1 vote203 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote222 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
2 votes198 views1 answer
Get first 2 letter in sql
SQL
0 vote203 views1 answer
Sql add calculated column
SQL
0 vote259 views1 answer
Mql5 datetime get hour
SQL
0 vote210 views1 answer
Drop all triggers oracle
SQL