Answer / shilpa.oracle

Advantage:
Using cursors we can retrieve multiple records in a plsq block.

Disadvantage:
switching between the plsql statement executor and sql
statement executor at plsql runtime engine will consume time.

Answer / swapna

advantage :

In pl/sql if you want perform some actions more than one
records you should user these cursors only. By using these
cursors you process the query records. you can easily move
the records and you can exit from procedure when you
required by using cursor attributes.


disadvantage:

using implicit/explicit cursors are depended by Situation.
If the result set is les than 50 or 100 records it is
better to go for implicit cursors. if the result set is
large then you should use exlicit cursors. other wise it
will put burdon on cpu.

what is column? : Sql dba

0 Answers  

---

How to test for null values?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

What is a stored procedure in sql with example?

0 Answers  

---

what is data integrity

3 Answers   Fidelity, TCS,

---

how to rename an existing table in mysql? : Sql dba

0 Answers  

---

how to drop an existing view in mysql? : Sql dba

0 Answers  

---

What is sql prepared statement?

0 Answers  

---

What is a transaction?

5 Answers  

---

Which data type doesn't allow null data type?

6 Answers   TCS,

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

Is join same as left join?

0 Answers  

---