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.

Why is nosql good?

0 Answers  

---

What is offset and limit in sql?

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

What packages(if any) has oracle provided for use by developers?

1 Answers  

---

Does truncate require commit?

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

What is the mutating table and constraining table?

0 Answers  

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

What does the sign mean in sql?

0 Answers  

---

How do you change a value in sql?

0 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---