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

10 votes289 views1 answer
Oracle view dependencies
SQL
0 vote276 views1 answer
Implicit inner join table alias
SQL
3 votes267 views2 answers
Df to sql pandas sql achemy
SQL
4 votes277 views1 answer
Search column by name mysql
SQL
0 vote277 views1 answer
How to add timestamp column in mysql
SQL
0 vote256 views1 answer
Sql server delete records with specific date
SQL
0 vote213 views2 answers
Jupyter notebook connect to database
SQL
0 vote259 views1 answer
Snap craft
SQL
0 vote265 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote256 views1 answer
Rabbitmq service not starting
SQL