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

0 vote309 views1 answer
Get time component of datetime sql
SQL
31 votes323 views4 answers
How to get duplicate records with multiple field in sql
SQL
2 votes353 views1 answer
Sql percentage with % rounded down
SQL
0 vote319 views1 answer
Drop all triggers oracle
SQL
0 vote304 views1 answer
Show all mongodb
SQL
18 votes318 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote316 views1 answer
Sql query interview questions githu
SQL
0 vote345 views1 answer
Sql sum show 0 result
SQL
2 votes324 views2 answers
How to check data type in sql server
SQL
3 votes310 views4 answers
Show columns from table
SQL