Difference between an implicit & an explicit cursor.?
- 2 Answers
- 6760 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 is the difference between restoring and recovering?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Can we commit inside a function in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
how to clone 9i Database on to 10g Database.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain the use of ignore option in imp command.
Can I create users through internet explorer in oracle 10g?
How to do a full database export?
What is the difference between substr and instr?
 What are the oracle DML commands possible through an update strategy?
Explain the use of inctype option in exp command.
Is it possible to split the print reviewer into more than one region ?
what is the difference between data migration and production migration.
