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

0 vote145 views1 answer
Python dictionary to sql update
SQL
0 vote137 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
3 votes129 views1 answer
Sql server version query
SQL
1 vote133 views1 answer
Sql current timestamp
SQL
0 vote147 views1 answer
Mariadb disable foreign key checks
SQL
45 votes210 views5 answers
Grant all privileges mysql
SQL
0 vote126 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote96 views1 answer
Store query result in variable sql
SQL
0 vote126 views1 answer
Mysql convert charset
SQL
0 vote126 views1 answer
Data directory postgresql
SQL