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 vote118 views1 answer
Addition of 2 column value in mysql
SQL
4 votes115 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
2 votes109 views1 answer
Mysql add boolean column
SQL
0 vote126 views1 answer
Oracle drop type
SQL
0 vote111 views1 answer
Sql insert tuple
SQL
0 vote111 views1 answer
Pl/sql loop example
SQL
0 vote118 views1 answer
Sql server count all tables rows
SQL
19 votes112 views6 answers
Sql create table
SQL
0 vote102 views1 answer
Sql create text column limited values
SQL
25 votes148 views4 answers
Import mysql dump command line
SQL