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 vote108 views1 answer
Creation d'un trigger sql
SQL
0 vote102 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote114 views1 answer
Casterar postgres
SQL
0 vote113 views1 answer
Nodejs sql get one to many relationship as array
SQL
2 votes106 views1 answer
Find all triggers in database
SQL
0 vote102 views1 answer
Sql case sttement with set
SQL
11 votes109 views2 answers
Turn off safe mode mysql
SQL
8 votes123 views4 answers
Reset SQL auto increment
SQL
1 vote109 views1 answer
Oracle enable job
SQL
0 vote103 views2 answers
Plan d'exécution requete oracle autotracer
SQL