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

1 vote206 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote200 views1 answer
Sql basic commands
SQL
3 votes230 views1 answer
Query less than datetime sql
SQL
7 votes170 views1 answer
Minecraft forge server host
SQL
0 vote187 views1 answer
Postgresql import a database of gzip
SQL
3 votes173 views1 answer
Sql case update
SQL
16 votes175 views3 answers
Tsql rename column name
SQL
9 votes221 views3 answers
Pyodbc connect to sql server
SQL
0 vote195 views1 answer
Add column in sql server ubuntu
SQL
1 vote176 views1 answer
Mysql backup skip table
SQL