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 vote138 views1 answer
Transaction database with php
SQL
1 vote142 views2 answers
Difference between in and between in sql
SQL
0 vote148 views1 answer
What is between keyword used for
SQL
0 vote141 views1 answer
Sql quary intervewi question
SQL
2 votes97 views2 answers
Mysql get last character of string
SQL
3 votes191 views1 answer
Oracle function
SQL
1 vote145 views1 answer
Find a column in all tables postgres
SQL
1 vote131 views1 answer
Sql auto timestamp
SQL
8 votes139 views2 answers
Update sql server from another table
SQL
0 vote192 views1 answer
Postgres extract number from string
SQL