1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How can we schedule the procedure to run automatically ?

Question Posted / swapna

Answers were Sorted based on User's Feedback



How can we schedule the procedure to run automatically ?..

Answer / mahesh

By using dbms_job (buitin package upto oracle 9i)
and using dbms_scheduler (oracle 10G onwrds)

Is This Answer Correct ?    7 Yes 0 No

How can we schedule the procedure to run automatically ?..

Answer / 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

How can we schedule the procedure to run automatically ?..

Answer / swapna

We Can Schedule The Procedure Run Automatically By Using
Packages.

Is This Answer Correct ?    6 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

How do you modify a column in sql?

0 Answers  

What is the use of sql trace?

0 Answers  

How can I delete duplicate rows?

0 Answers  

why we use nocopy?

2 Answers   Polaris,

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  




What is foreign key sql?

0 Answers  

How to get list of all tables from a database?

0 Answers  

Why join is faster than subquery?

0 Answers  

What is the difference between the implicit and explicit cursors?

0 Answers  

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

How do you take the union of two tables in sql?

0 Answers  

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

For more SQL PLSQL Interview Questions Click Here
Categories