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 vote220 views1 answer
Mysql calculated column
SQL
1 vote213 views1 answer
User privileges postgresql information_schema
SQL
0 vote200 views1 answer
How to remove default in mysql
SQL
2 votes245 views1 answer
Oracle Column Names of a table
SQL
8 votes178 views2 answers
Alter column name in mssql
SQL
0 vote255 views1 answer
Get last inserted primary key
SQL
0 vote206 views1 answer
On update current_timestamp jpa
SQL
0 vote164 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote262 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
11 votes234 views5 answers
Laravel db facade
SQL