Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7400 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which environment variables are absolutely critical in order to run the OUI?
Where are the settings stored for each instance in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to install oracle database 10g xe?
What is an oracle transaction?
Explain the use of grant option in imp command.
how to make an oracle object
Explain oracle instance.
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to save query output to a local file?
How to use like conditions in oracle?
State the various uses of dbcc command?
What is a view and how is it different from a table?
How to start an oracle instance?
How to view existing locks on the database?
