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

3 votes179 views2 answers
Brew start mysql
SQL
0 vote199 views2 answers
How to count codition
SQL
0 vote192 views2 answers
Port 5432 is already in use mac
SQL
0 vote169 views1 answer
Get first name and last name from full name string in SQL
SQL
2 votes194 views3 answers
Current setting postgres timezone
SQL
1 vote156 views1 answer
Can we drop a primary key
SQL
18 votes166 views4 answers
Foreign key mySql
SQL
1 vote180 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote179 views1 answer
Oracle list proxy users
SQL
0 vote173 views1 answer
Postgres select except
SQL