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
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Does google use sql?
which types of join is used in sql widely? : Sql dba
What is the advantage of index in sql?
What are the different types of tables in sql?
What is information schema in sql?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
How do you write an inner join query?
What is a constraint? Tell me about its various levels.
What is not null in sql?
Is big data nosql?
What are the different types of a subquery?
what is dbms? : Sql dba
What are expressions?
difference between anonymous blocks and sub-programs.