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 materialized view in sql?

926

What is the requirement of self-join?

1135

Is crud a cuss word?

1040

Which is faster count (*) or count 1?

1041

What is hibernate and its relation to sql?

1131

What are synonyms in sql?

976

Explain cursor types?

1034

What is the difference between delete, truncate and drop command?

1161

Show code of a cursor for loop.

1065

What is application trigger?

1004

What is record type in pl sql?

1001

What is difference between db2 and sql?

1009

What is sql select statement?

1042

What is trigger explain with example?

1046

What is right join sql?

969