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

2 votes399 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote436 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote358 views1 answer
Postgresql delete limit
SQL
25 votes370 views5 answers
Date in mysql
SQL
18 votes321 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote349 views1 answer
Output to file mysql
SQL
0 vote339 views1 answer
T sql return on letters only
SQL
0 vote364 views1 answer
How to to get time in sql
SQL
0 vote312 views1 answer
Get only first row mysql
SQL
0 vote366 views1 answer
Mysql Selected All Duplicate Rows
SQL