Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7530 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 use of system.effective.date variable in oracle?
What is the exact use of Collections?
What is save point in oracle database?
Explain the use of parfile option in exp command.
What is bulk copy or bcp in oracle?
What is a static data dictionary in oracle?
What is the string concatenation operator in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What types of joins are used in writing subqueries?
How to create a new table in your schema?
How to assign data of the deleted row to variables?
Give the different types of rollback segments.
How to write an inner join with the where clause in oracle?
What are the various oracle database objects?
What happens if you set the sga too low in oracle?
