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 trigger in sql?

0 Answers  

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

Why do we need databases?

0 Answers  

---

Can we enter data in a table in design view?

0 Answers  

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

---

What is an inconsistent dependency?

0 Answers  

---

How to add new employee details in an employee_details table with the following details

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

What are properties of the transaction?

0 Answers  

---

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

---

What is denormalization in a database?

0 Answers  

---

What is difference between hql and sql?

0 Answers  

---