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

4 votes359 views4 answers
Rollback in sql
SQL
0 vote364 views1 answer
Make parameters nullable in sql server
SQL
5 votes363 views1 answer
How to get all table names in sql query
SQL
0 vote389 views1 answer
How to compile a function in oracle
SQL
0 vote330 views1 answer
Sql orcale i forgot what my name & password was
SQL
6 votes351 views2 answers
Postgresql restore from dump
SQL
0 vote368 views2 answers
Mysql update two tables at once
SQL
32 votes362 views6 answers
How to change column name in sql
SQL
0 vote343 views1 answer
Get foreign table names mysql
SQL
0 vote388 views1 answer
Mysql create index lost connection
SQL