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 vote317 views1 answer
Find all tables where column name exists oracle
SQL
0 vote371 views3 answers
Mysql CAST(amount as float)
SQL
1 vote323 views2 answers
List tables sqlalchemy
SQL
3 votes336 views2 answers
Install mysql powershell
SQL
2 votes316 views1 answer
Oracle find unusable indexes
SQL
0 vote304 views0 answer
SQL
0 vote308 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
8 votes349 views4 answers
Reset SQL auto increment
SQL
0 vote339 views1 answer
Example database query
SQL
1 vote358 views1 answer
Nvl postgres
SQL