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.

can i give user defined exception in a package

2 Answers  

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

what is the different between unique+not null & primary key,

4 Answers  

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

Can we rollback truncate?

0 Answers  

---

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

What are sql queries used for?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

How do I remove sql plus from windows 10?

0 Answers  

---