Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7385 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
What are the logical operations?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What happens to indexes if you drop a table?
What is oracle in java?
How to use attributes of the implicit cursor in oracle?
Explain about achiever in sql?
What is Redo Log Buffer in Oracle?
How to define a data source name (dsn) in odbc manager?
What are the different types of trigger and explain its various uses and functions?
What is the order of defining local variables and sub procedures/functions?
What are dml statements in oracle?
How to loop through data rows in the implicit cursor?
What are the differences between interval year to month and interval day to second?
What are the differences between date and timestamp in oracle?
