How can we schedule the procedure to run automatically ?
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 are integrity rules?
how to extract a unit value from a date and time? : Sql dba
What are aggregate and scalar functions?
Explain architecture of sql server notification services?
what is the difference between sql and t-sql? : Transact sql
how many ways we can we find the current date using mysql? : Sql dba
How do you create a db file?
can sql servers linked to other servers like oracle? : Sql dba
What do you think about pl/sql?
How can you load multi line records? : aql loader
What is indexing oracle sql?
What is the purpose of a secondary key?
What is dialect in sql?
What are tables and fields in the database?
What is package in pl sql with an examples?