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

3 votes174 views1 answer
Mysql group_concat distinct
SQL
40 votes171 views6 answers
Update table mysql
SQL
3 votes107 views1 answer
Laravel database Using Named Bindings
SQL
-1 vote114 views1 answer
Sql set max value in column
SQL
0 vote115 views1 answer
Oracle concat datetime
SQL
8 votes99 views1 answer
Oracle add month
SQL
0 vote125 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote105 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote115 views1 answer
Get last updated row sql server
SQL
1 vote127 views2 answers
Drop table with constraints
SQL