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

103 votes2.5K views1 answer
Like sql
SQL
0 vote270 views1 answer
Month mysql
SQL
0 vote204 views1 answer
Addition of 2 column value in mysql
SQL
1 vote206 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
9 votes230 views2 answers
Sql server check table exists
SQL
3 votes294 views2 answers
Savepoint in sql
SQL
0 vote243 views1 answer
Postgresql alter table sequence
SQL
0 vote207 views2 answers
Pop sql insert value into
SQL
1 vote221 views1 answer
Lpad function in sql oracle
SQL
0 vote236 views1 answer
Sql order by number not ordered
SQL