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 vote186 views1 answer
Sqlite update only if greater
SQL
2 votes187 views2 answers
Exec procedure pl sql
SQL
0 vote199 views1 answer
Postgres statistics
SQL
15 votes186 views4 answers
Mysql where value is null
SQL
0 vote216 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote204 views1 answer
Sqlite3 update select
SQL
10 votes193 views4 answers
Sql pagination
SQL
3 votes193 views3 answers
Postgresql random number
SQL
1 vote287 views1 answer
Sql server read uncommitted
SQL
0 vote199 views1 answer
Find and replace query in wordpress\
SQL