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

1 vote290 views1 answer
Delete specific row in sql
SQL
25 votes306 views4 answers
Sqlserver add column
SQL
0 vote289 views1 answer
How to select only id where is not in column mysql
SQL
0 vote302 views1 answer
View t-sql mail configuration
SQL
0 vote312 views1 answer
Get primary key of table
SQL
0 vote292 views1 answer
Sql server select record with max id
SQL
0 vote299 views1 answer
Get who is hired in february in sql
SQL
0 vote286 views1 answer
Create date sql
SQL
6 votes295 views1 answer
Oracle list primary key
SQL
-2 votes283 views1 answer
Use of where in left join in mysql
SQL