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 vote204 views1 answer
Mysql query bulk insert
SQL
0 vote190 views1 answer
How to to get current date and time in sql
SQL
3 votes219 views3 answers
1396(hy00) mysql error
SQL
1 vote183 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
2 votes186 views1 answer
How to select first row of database sql
SQL
1 vote193 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote184 views1 answer
Create bakupd database sqlserver
SQL
0 vote243 views1 answer
Delete from table where length sql
SQL
0 vote232 views2 answers
Drop tables from local table database postgres
SQL
-2 votes199 views2 answers
Sqlserver docker
SQL