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 vote284 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote247 views1 answer
Update set with join pl sql
SQL
0 vote288 views1 answer
Postgres change the name of schema
SQL
2 votes283 views2 answers
How to run postgresql in linux
SQL
2 votes287 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote276 views1 answer
Group by join columns per table
SQL
0 vote314 views1 answer
Generate a random otp in sql server
SQL
4 votes268 views1 answer
Create db table
SQL
0 vote276 views1 answer
Limit in access query
SQL
1 vote234 views1 answer
Stored procedure return value
SQL