Answer / v.ramesh

Implicit cursor is taken care by oracle server only,when we write any statement or query in the SQL editor,in that case oracle server create some memory for that and do operation on that query and finally erase the space as well

in case of Explicit cursor,manually like we need to create the Cursor and open.fetch the data and close the cursor.

we have one more alternative for this,if we will create cursor we need to user FOR LOOP mechanism in this case all exlicit cursor are not needed i.e OPEN<FETCH<CLOSE

Answer / basanti

IMPLICIT CURSOR: When we execute any sql statement, PL/SQL creates implicit cursor and manages automatically means implcit open & close takes place. It used when sql statement return only one row.
It has 4 attributes SQL%ROWCOUNT, SQL%FOUND, SQL%NOTFOUND, SQL%ISOPEN.

EXPLICIT CURSOR: It is created & managed by the programmer. It needs every time explicit open,fetch & close.
It is used when sql statement returns more than one row.
It has also attributes CUR_NAME%ROWCOUNT, CUR_NAME%FOUND, CUR_NAME%NOTFOUND, CUR_NAME%ISOPEN.

waht is the difference between primary key and super key?

9 Answers  

---

how to store only time in a data base table

2 Answers  

---

How to recover a dropped index?

1 Answers  

---

How do I spool in oracle?

0 Answers  

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

How to define a procedure inside another procedure?

0 Answers  

---

How do I learn what codesets are available in oracle?

0 Answers  

---

What is an oracle user account?

0 Answers  

---

How do you rate yourself in oracle and sql server ?

2 Answers   Keane India Ltd,

---

How to retrieve values from data fields in record variables?

0 Answers  

---

am completed mca2011 how get certification in oracle

1 Answers  

---

how to tune oracle sql queries pls tell me step by step. urgent pls

1 Answers  

---