Answer / mahesh

By using dbms_job (buitin package upto oracle 9i)
and using dbms_scheduler (oracle 10G onwrds)

Answer / nakul.v

We can Schedule a Stored Procedure to run automatically
once we attach the Procedure to a Package and use the
Built – In DBMS_JOB Package.
DBMS_JOB.SUBMIT & DBMS_JOB.RUN will help us to Schedule a
Stored Procedure

Answer / swapna

We Can Schedule The Procedure Run Automatically By Using
Packages.

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

Which command is used to call a stored procedure?

0 Answers  

---

How many types of relationship are there?

0 Answers  

---

What are triggers, and when would you use them?

3 Answers  

---

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

---

What does where 1/2 mean in sql?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

define sql

3 Answers   Zensar,

---

What is trigger types of trigger?

0 Answers  

---

How to find string or key value using pl/sql code?

2 Answers   Ramco,

---

What are the different types of database management systems?

0 Answers  

---

what are the advantages of cursors than procedures?

2 Answers  

---