Answer / Sumit Rajput

1. Create a PL/SQL block or procedure with the necessary logic for the job. 2. Register the PL/SQL block or procedure as a DBMS_SCHEDULER job using the ADD_JOB function. 3. Define a job chain or schedule to run the job using the ADD_JOB_CHAIN or CREATE_JOB_SCHEDULE functions. 4. Enable the job and start the execution using the START_JOB or RUN_JOB_NOW functions.

Which data type is a composite type?

1 Answers  

---

What is the process of copying data from table a to table b?

1 Answers  

---

What is lexical units in pl sql?

1 Answers  

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

what are all the common sql function? : Sql dba

0 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1 Answers  

---

What is cascade in sql?

1 Answers  

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---

Can we rename a column in the output of sql query?

1 Answers  

---

What is a .db file?

1 Answers  

---

What are the types of join in sql?

1 Answers  

---

What is sql clause?

1 Answers  

---