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

Can variables be used in sql statements?

1073

What do you mean by dbms? What are its different types?

1062

What is trigger explain with example?

1091

What is auto increment?

1044

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

1214

what is 'mysqlshow'? : Sql dba

1073

Explain what is a subquery ?

1242

What is type and rowtype in pl sql?

1055

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1286

Can we use update in sql function?

1115

What does rownum mean in sql?

1089

Show how functions and procedures are called in a pl/sql block.

1183

What is cursor in pl sql?

1185

What is the difference between a query and a report?

1053

Does user triggers have entry for trigger with compilation errors?

1089