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 microsoft t sql?

0 Answers  

---

what is a constraint? : Sql dba

0 Answers  

---

How do I view output in sql developer?

0 Answers  

---

What is composite primary key in sql?

0 Answers  

---

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

0 Answers  

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

Where is sql database stored?

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

What are the different tcl commands in sql?

0 Answers  

---

What are the possible values that can be stored in a boolean data field?

0 Answers  

---

What is pl/sql language case sensitive?

0 Answers  

---

What is a composite primary key?

0 Answers  

---