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,

---

Why do we need databases?

0 Answers  

---

How to avoid using cursors?

0 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

---

What are inner and outer joins examples of both?

0 Answers  

---

What is record variable?

0 Answers  

---

How to move files from one directory to another in pl sql?

0 Answers  

---

what is 'trigger' in sql? : Sql dba

0 Answers  

---

What is difference between group by and partition by?

0 Answers  

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

What is difference between sql and mysql?

0 Answers  

---