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
Do we need to create index on primary key?
Why truncate is faster than delete?
List the different type of joins?
What is a sql schema used for?
What are pl/sql cursors?
what are different types of collation sensitivity? : Sql dba
Explain the uses of a database trigger?
How do I remove sql plus from windows 10?
how to get @@error and @@rowcount at the same time? : Sql dba
Can we use pl sql in mysql?
Which function is used to return remainder in a division operator in sql?
What are the two types of periodical indexes?
What's the procedure?
Is like operator in sql case sensitive?
Can you skip header records while loading? : aql loader