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 vote250 views1 answer
Truncate left characters mysql
SQL
-1 vote274 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote262 views1 answer
Python connect microsoft sql server
SQL
0 vote246 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
1 vote291 views1 answer
UseSqlServer no definition
SQL
0 vote253 views1 answer
Syntax for changing column size in mysql
SQL
0 vote263 views1 answer
Sql alter column name sql server
SQL
1 vote264 views1 answer
Sqlalchemy order_by
SQL
9 votes267 views6 answers
Replace sql
SQL
11 votes253 views1 answer
Ddl materialized view
SQL