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

6 votes237 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote224 views1 answer
Denied
SQL
0 vote298 views2 answers
Unique key
SQL
4 votes290 views2 answers
Linq join
SQL
3 votes283 views1 answer
Fk in insert mysql
SQL
0 vote282 views1 answer
Systems sql
SQL
11 votes296 views3 answers
How to get last row of table in sql
SQL
2 votes302 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote258 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
3 votes273 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL