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

5 votes251 views1 answer
Find table from column name in sql
SQL
1 vote239 views1 answer
Homebrew install mysql
SQL
0 vote289 views1 answer
How many rows affected in sqllite
SQL
0 vote259 views1 answer
Sqlite trim
SQL
0 vote284 views1 answer
Sql delete caracter list
SQL
0 vote198 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote252 views1 answer
Sql tablo sp
SQL
1 vote190 views1 answer
Jooq convert using gbk
SQL
1 vote170 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote208 views1 answer
How to use group_concat in sql server
SQL