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 vote226 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote180 views1 answer
Ms sql unique
SQL
1 vote229 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
4 votes195 views1 answer
Check database name postgresql
SQL
20 votes228 views1 answer
Get all table name in sql through php
SQL
3 votes199 views1 answer
Show index table
SQL
0 vote226 views1 answer
Mysql get hour from datetime
SQL
0 vote191 views1 answer
Mysql percentage of total
SQL
0 vote213 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote190 views1 answer
Get only structure database mysql
SQL