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

What is trigger price?

536


What are operators available in sql?

583


How many commands are in sql?

521


Explain the significance of the & and && operators in pl sql.

567


What's the difference between inner join and left join?

510






How do I run pl sql in sql developer?

624


If a cursor is open, how can we find in a pl/sql block?

669


What can you do with pl sql?

554


What is cursor status?

761


Why do we use sql constraints? Which constraints we can use while creating database in sql?

543


what is a stored procedure? : Sql dba

546


what is the syntax for using sql_variant_property? : Transact sql

527


What will you get by the cursor attribute sql%rowcount?

547


List the different type of joins?

566


What are the qualities of 2nf?

541