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

What is Collation Sensitivity ? What are the various type ?

904

What is Histogram?

1504

What is the use of count (*) in sql?

980

What is the requirement of self-join?

1025

What is the benefit of foreign key?

960

What does the file extension accdb stand for?

916

Is id a reserved word in sql?

1090

what are integrity rules?

964

What is update query?

920

How do I run a query in pl sql developer?

925

Can a key be both primary and foreign?

943

Does sql require a server?

942

What is rowtype?

954

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

916

what are the types of join and explain each? : Sql dba

989