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

8 votes229 views4 answers
Mysql update one table from another table multiple columns
SQL
1 vote245 views5 answers
What is in operator in sql
SQL
0 vote441 views1 answer
How to connect .sql data set to powerbi
SQL
1 vote241 views2 answers
Oracle list service names
SQL
-1 vote212 views10 answers
Delete Query in SQL Server
SQL
2 votes221 views1 answer
Mysql list users on ubuntu
SQL
0 vote241 views1 answer
Query params sql insert python f string
SQL
0 vote276 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote238 views1 answer
Sql server count all tables rows
SQL
0 vote243 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL