How can we schedule the procedure to run automatically ?
Answer Posted / 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 |
Post New Answer View All Answers
how to create a test table in your mysql server? : Sql dba
What is the execution plan in sql?
What is data modelling in sql?
What is the difference between join and natural join?
How to read/write files from pl/sql?
What are schema-level triggers?
how can we repair a mysql table? : Sql dba
How many types of index are there?
Explain what is a subquery ?
How do you rename a table in sql?
What is the difference between subquery and correlated query?
What is crud sql?
What is a schema sql?
How do you change a value in sql?
What is the current version of sql?