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
What is trigger price?
What are operators available in sql?
How many commands are in sql?
Explain the significance of the & and && operators in pl sql.
What's the difference between inner join and left join?
How do I run pl sql in sql developer?
If a cursor is open, how can we find in a pl/sql block?
What can you do with pl sql?
What is cursor status?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
what is a stored procedure? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
What will you get by the cursor attribute sql%rowcount?
List the different type of joins?
What are the qualities of 2nf?