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 vote137 views1 answer
On update current_timestamp jpa
SQL
4 votes126 views4 answers
Rollback in sql
SQL
0 vote107 views2 answers
Avg() sql
SQL
8 votes159 views3 answers
Find table for column name in sql
SQL
16 votes134 views2 answers
Gremove folder from git
SQL
0 vote165 views1 answer
Sql today at midnight
SQL
0 vote96 views2 answers
Sql query unique
SQL
3 votes139 views2 answers
Mysql HAVING
SQL
0 vote131 views1 answer
Mysql calculated column
SQL
0 vote205 views1 answer
Connect google bigquery connect using sqirrel
SQL