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
Mention what is the plv (pl/vision) package offers?
How do I debug a stored procedure?
How do I count rows in sql?
What are the benefits of triggers?
How do I filter in sql profiler?
What are the advantages of sql?
What is the difference between nested table and varray?
How is a process of pl/sql compiled?
Does truncate table reset auto increment?
How to convert comma separated string to array in pl/sql?
How do I view output in sql developer?
How can you tell the difference between an index and a view?
what is isam? : Sql dba
What is update query?
What is a recursive stored procedure?