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

7 votes354 views2 answers
Oracle foreign key reference table
SQL
2 votes383 views1 answer
Q operator in oracle
SQL
5 votes376 views1 answer
Purge undo tablespace usage
SQL
17 votes409 views4 answers
Show all tables in oracle
SQL
12 votes353 views4 answers
Import mysql database command line linux
SQL
5 votes340 views1 answer
Mysql change primary key
SQL
0 vote334 views1 answer
Bigquery declare
SQL
0 vote390 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
4 votes345 views1 answer
Oracle select first 10 rows
SQL
3 votes304 views1 answer
How to get list of synonyms in oracle
SQL