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

0 vote206 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote189 views3 answers
Execute sp in sql server
SQL
0 vote241 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote183 views1 answer
Change default schema sql server
SQL
4 votes209 views1 answer
Oracle nls_date_format
SQL
3 votes279 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
-1 vote216 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
17 votes211 views3 answers
Postgresql version command
SQL
2 votes236 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
1 vote213 views2 answers
Remove space in mysql
SQL