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


Please Help Members By Posting Answers For Below Questions

how to create a test table in your mysql server? : Sql dba

581


What is the execution plan in sql?

669


What is data modelling in sql?

608


What is the difference between join and natural join?

563


How to read/write files from pl/sql?

666






What are schema-level triggers?

660


how can we repair a mysql table? : Sql dba

622


How many types of index are there?

635


Explain what is a subquery ?

760


How do you rename a table in sql?

633


What is the difference between subquery and correlated query?

627


What is crud sql?

627


What is a schema sql?

627


How do you change a value in sql?

632


What is the current version of sql?

649