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 we alter stored procedure?

0 Answers  

---

Why schema is used in sql?

0 Answers  

---

What type of database is sql?

0 Answers  

---

What are data types in pl sql?

0 Answers  

---

How do I add a database to sql?

0 Answers  

---

What is right join sql?

0 Answers  

---

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

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

How would you pass hints to the sql processor?

0 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---