Types of cursors and explanation each of them ?
Answer Posted / anusha
Cursor is a private work area .there are
three types if cursors
1.implicit cursor: implicit cursors is create,open and
closed by system automatically.
2.explicit cursor: explicitly user can create,open and close
cursors.
3. ref cursor: Reference cursor is a cursor dynamically (at
Run time) we can pass the column names or table names.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to select 10 records from a table?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How can you tell the difference between an index and a view?
What is memory optimized?
Write a sql query to find the names of employees that begin with ‘a’?
What is sql in java?
What mean sql?
What happens when a trigger is associated to a view?
What kind of join is join?
Is crud a cuss word?
How do I order by ascending in sql?
What is auto increment feature in sql?
Why is sql better than hql?
Why is normalization important?
Do foreign keys improve performance?