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

-2 votes250 views1 answer
Use of where in left join in mysql
SQL
0 vote270 views1 answer
Python list from sql
SQL
16 votes252 views4 answers
Sort by sql
SQL
0 vote238 views1 answer
Trim sql oracle
SQL
23 votes256 views4 answers
How to uninstall postgresql in ubuntu
SQL
3 votes267 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote325 views1 answer
Delete ids between sql
SQL
0 vote259 views1 answer
Cross apply top for each row t1
SQL
0 vote252 views2 answers
Sql drop view if exists
SQL
0 vote247 views1 answer
Update one column from another column in same table
SQL