How can we schedule the procedure to run automatically ?
- 3 Answers
- 10326 Views
- I also Faced
- E-Mail Answers
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
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
what is the command used to fetch first 5 characters of the string? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
how to use regular expression in pattern match conditions? : Sql dba
What are the different types of dbms?
What are the types of variable use in pl sql?
Is sql low level language?
what is 'mysqlimport'? : Sql dba
How can triggers be used for the table auditing?
What is pivot table in sql?
what is the difference between $message and $$message? : Sql dba
Are stored procedures faster than dynamic sql?
What operating systems are supported by oracle sql developer?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What are all the common sql functions?
