How can we schedule the procedure to run automatically ?
- 3 Answers
- 10317 Views
- I also Faced
- E-Mail Answers
Answer Posted / nakul.v
We can Schedule a Stored Procedure to run automatically
once we attach the Procedure to a Package and use the
Built – In DBMS_JOB Package.
DBMS_JOB.SUBMIT & DBMS_JOB.RUN will help us to Schedule a
Stored Procedure
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is implicit cursor in pl sql?
What is cte sql?
Is it possible to create the following trigger: before or after update trigger for each row?
How to take user input in pl sql?
Mention what does the hierarchical profiler does?
Give the order of sql select?
what is the difference between inner and outer join? Explain with example. : Sql dba
How many unique keys can a table have?
What is index example?
Is sql harder than python?
What is clustered and nonclustered index in sql?
define sql delete statement ? : Sql dba
how to write date and time literals? : Sql dba
Can two tables have same primary key?
What is sql not null constraint?
