Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7270 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 different types of modules in oracle forms?
How to write text literals in oracle?
How many types of synonyms in Oracle?
Can we insert data in view oracle?
How to connect to oracle using service name instead of sid?
What are the data types in oracle?
Which is faster join or subquery in oracle?
What is a user account in oracle?
What is integrity and what is constraint??Explain with example
What is ADDM Advisor in Oracle?
How to apply filtering criteria at group level in oracle?
How to use subqueries with the in operator using oracle?
What does sharding mean?
What is recovery manager in Oracle?
Can you have more than one content canvas view attached with a window ?
