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

5 votes292 views4 answers
Mysql update column with value from another table
SQL
1 vote299 views5 answers
What is in operator in sql
SQL
7 votes270 views1 answer
Postgres base size
SQL
1 vote278 views1 answer
Show structure of table in sql
SQL
2 votes267 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote279 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote277 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
14 votes295 views2 answers
Install mysqldump
SQL
1 vote276 views1 answer
How to find median of a column sql
SQL
5 votes288 views1 answer
Sql select ciunt
SQL