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 vote187 views1 answer
How to alter length character varying postgres
SQL
0 vote156 views1 answer
Order by with where clause in mysql
SQL
0 vote199 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote186 views3 answers
Sql query checker
SQL
0 vote192 views1 answer
How to find date from date table in sql
SQL
0 vote170 views1 answer
Mysql cast null to string
SQL
7 votes170 views3 answers
Sql get last inserted row
SQL
0 vote176 views2 answers
Psql commande \gset
SQL
2 votes164 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote163 views1 answer
How to fix mysql stop unexpectedly
SQL