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 are the different tables present in mysql? : Sql dba

0 Answers  

---

what is auto increment? : Sql dba

0 Answers  

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

How to raise user-defined exception with custom sqlerrm ?

0 Answers  

---

What is the difference between join and natural join?

0 Answers  

---

What is mutating error in pl sql?

0 Answers  

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

---

What are the advantages of sql?

0 Answers  

---

What is replication id?

0 Answers  

---

What are schema-level triggers?

0 Answers  

---

Is mariadb nosql?

0 Answers  

---

how to delete an existing column in a table? : Sql dba

0 Answers  

---