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

0 vote188 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
-1 vote191 views1 answer
How to dump .csv file into mysql
SQL
0 vote220 views1 answer
Update sql sintax
SQL
0 vote174 views1 answer
Oracle for loop on list
SQL
11 votes194 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote195 views1 answer
Postgresql replace html tags from string
SQL
0 vote168 views1 answer
Name '_mysql' is not defined
SQL
2 votes199 views1 answer
SQL IF ELSE
SQL
0 vote189 views1 answer
Add sqlite3 in lumen
SQL
0 vote188 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL