Types of cursors and explanation each of them ?
Answer Posted / sohail
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.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Is postgresql a nosql database?
Can variables be used in sql statements?
What does t sql mean?
what are the types of join and explain each? : Sql dba
What is meant by temporal data?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is a procedure in pl sql?
What is composite data type in pl sql?
what is the syntax used for partition in tsql? : Transact sql
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What are types of indexes in sql?
How to use sql statements in pl/sql?
How to set up sql*plus output format in oracle?
What are the types of optimization?
What is a .db file?