How do you write an index?

0 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

Does pl/sql support create command?

0 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

---

What is the difference between partition and index?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

What is over () in sql?

0 Answers  

---

What is right join sql?

0 Answers  

---

What is the difference between database trigger and stored procedure?

0 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

How to avoid using cursors?

0 Answers  

---