Types of cursors and explanation each of them ?
Answer Posted / giri
Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.sql%found,sql%notfound,sql%is open,sql%count these are the implicit cursor attributes.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.%found,%notfound,%is open,%count these are the explicit cursor attributes.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sql integrity?
How can we avoid duplicating records in a query?
What is an example of translating a date into julian format?
What are pl sql procedures?
how can we know the number of days between two given dates using mysql? : Sql dba
What is the difference between left outer join and left join?
Could you please provide oca (oracle 10g) dumps for my certification ?
Can we use join in subquery?
How do I write a sql query in pgadmin 4?
What do we need to check in database testing?
What do you mean by “trigger” in sql?
Is not null in sql?
Show the cursor attributes of pl/sql.
How is pl sql different from sql?
Explain mutating table error.