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

1 vote217 views1 answer
Postgres format date in select
SQL
0 vote215 views1 answer
Hex string sql becomes int64
SQL
0 vote203 views1 answer
How to select only id where is not in column mysql
SQL
0 vote226 views1 answer
Mysql add text to existing field
SQL
0 vote217 views1 answer
How convert into in in sql query
SQL
0 vote194 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote206 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote146 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote190 views3 answers
Above average salary in sql
SQL
36 votes311 views6 answers
Change column data type sql
SQL