How can we schedule the procedure to run automatically ?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / swapna
We Can Schedule The Procedure Run Automatically By Using
Packages.
Is This Answer Correct ? | 6 Yes | 5 No |
How many triggers can be applied to a table?
What is the maximum rows in csv?
write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)
What is varchar sql?
How do you update a table in sql?
What is pragma exception and how, when, where us
how many ways to get the current time? : Sql dba
What is the criteria while applying index to any column on any table.
how many tables will create when we create table, what are they? : Sql dba
What is consistency?
Can you alter start with clause?