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 votes321 views2 answers
Oracle synonym
SQL
0 vote319 views1 answer
Sql get table last modified time
SQL
18 votes332 views6 answers
Drop table if exists
SQL
1 vote361 views1 answer
Insert many to many sql
SQL
0 vote333 views2 answers
How to tun mysql on ubunto
SQL
0 vote322 views1 answer
How should I pass a table name into a stored proc?
SQL
1 vote323 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
1 vote377 views2 answers
This month mysql where
SQL
11 votes368 views2 answers
Having clause in sql
SQL
14 votes340 views1 answer
Sql value of string
SQL