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

3 votes236 views1 answer
Ssh check mysql version
SQL
3 votes134 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote194 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote143 views1 answer
Stored function in sql
SQL
16 votes131 views1 answer
Mysql mediumint max value
SQL
5 votes176 views3 answers
Sql limit offset
SQL
0 vote164 views1 answer
Split first name and last name in sql
SQL
5 votes132 views2 answers
Sql number columns
SQL
0 vote180 views1 answer
Postgres select from values
SQL
0 vote143 views1 answer
Less than date query sqlachemy
SQL