In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What is over () in sql?

0 Answers  

---

Can we rollback after truncate?

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  

---

What is partition by in sql?

0 Answers  

---

What are the events on which a database trigger can be based?

0 Answers  

---

What is the benefit of foreign key?

0 Answers  

---

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

Types of backups ?

3 Answers   TCS,

---

What do you mean by rowid?

0 Answers  

---