Interested to Buy Any Domain ? << Click Here >> for more details...
How can we schedule the procedure to run automatically ?
- 3 Answers
- 11203 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 are all the ddl commands?
What are the parts of a basic sql query?
What is the difference between python and sql?
How do I write a cron which will run a sql query and mail the results to agroup?
Why does sql need a server?
What is the difference between union and union all command?
Explain what is sql*plus?
What does seeding a database mean?
What is primary key and unique key?
How does join work in sql?
Which join is default?
Define commit, rollback and savepoint?
Can we rollback after truncate?
How to create an array in pl/sql?
Is vs as in pl sql?
