1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

What is pl sql package?

0 Answers  

---

Differentiate between pl/sql and sql?

0 Answers  

---

---

how to create a database in oracle?please gve anser with example

1 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

What is pivot query?

0 Answers  

---

Does view store data in sql?

0 Answers  

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---