Difference between an implicit & an explicit cursor.?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 2 Yes | 0 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
How do I reset a sequence in oracle?
Explain the function of optimizer in oracle?
What is the relationship among database, tablespace and data file?
How to create a new table by selecting rows from another table?
The join defined by the default data link is an outer join yes or no ?
What is a system tablespace?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
can you write commit in triggers?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to convert a date to char in oracle? Give one example.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is a Tablespace?