oracle create chain step

Solutions on MaxInterview for oracle create chain step by the best coders in the world

Search
showing results for - "oracle create chain step"
Lukas
18 Jun 2019
1BEGIN
2DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
3   chain_name      =>  'my_chain1',
4   step_name       =>  'my_step1',
5   program_name    =>  'my_program1');
6DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
7   chain_name      =>  'my_chain1',
8   step_name       =>  'my_step2',
9   program_name    =>  'my_chain2');
10END;
source
Eden
12 Oct 2020
1BEGIN
2DBMS_SCHEDULER.CREATE_CHAIN (
3   chain_name          => 'my_chain1',
4   rule_set_name       => NULL,
5   evaluation_interval => NULL,
6   comments            => 'My first chain');
7END;
source
similar questions
oracle job type chainoracle disable chainoracle drop chain ruleoracle multiple cte statementsoracle drop chain steporacle procedure chain steporacle list chain stepsoracle create procedure exampleoracle chain rulesoracle create chain rulecase statement in oracle with multiple conditions examplesoracle create sequenceoracle dynamic cursor for loop exampleoracle running chainoracle chain step succeededoracle create as selectoracle step procedureoracle dynamic select intocreate sequence in oracle 12coracle drop chainoracle enable chain
queries leading to this page
oracle create chain steporacle create chain step suceededoracle create chain step