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 vote234 views1 answer
Return size of tables in mysql
SQL
11 votes231 views2 answers
Docker create postgres db
SQL
0 vote244 views1 answer
Copy data from one postgres container to another
SQL
0 vote266 views2 answers
Mysql insert into multiple tables
SQL
2 votes247 views1 answer
Orcale index size
SQL
0 vote292 views1 answer
Intellij mysql set timezone
SQL
3 votes252 views1 answer
Start mysql server by terminal in linux
SQL
0 vote237 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
5 votes254 views3 answers
Postgres show databases
SQL
0 vote238 views2 answers
Sql use not in
SQL