By using dbms_job (buitin package upto oracle 9i) and using dbms

How can we schedule the procedure to run automatically ?

Question Posted / mahesh

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

Please Help Members By Posting Answers For Below Questions

How delete all data from all tables in sql?

933

What is compound trigger?

1016

Can a commit statement be executed as part of a trigger?

1036

how to extract a unit value from a date and time? : Sql dba

979

What is a nested table in word?

946

differentiate between float and double. : Sql dba

1037

What are the limitations of sql express?

1048

how to convert dates to character strings? : Sql dba

1142

How to load data with sql*loader?

1034

Are subqueries better than joins?

958

how mysql optimizes distinct? : Sql dba

1058

What is data modelling in sql?

1002

Does truncate table reset auto increment?

978

Explain the components of sql?

1044

What are sql procedures?

1006