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

0 vote190 views1 answer
Enable full text search mysql
SQL
0 vote196 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
4 votes191 views2 answers
Linq join
SQL
3 votes183 views1 answer
Search for column name in psql
SQL
3 votes205 views1 answer
Oracle limit user tablespace
SQL
7 votes194 views2 answers
Mysql get year from date
SQL
0 vote225 views1 answer
Count in sql and diff
SQL
9 votes187 views3 answers
Where in sql
SQL
1 vote339 views1 answer
Sql injection
SQL
-1 vote205 views3 answers
How to restart mysql in linux
SQL