Types of cursors and explanation each of them ?
Answer Posted / aditya
Ref cursor have two types strong ref cursor and weak ref cursor.
declaring a ref cursor and using it for multiple select statements is a weak cursor.
using a ref cursor as an out parameter to get a result set is a strong ref cursor.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between cursor and trigger?
Explain what is table in a database?
What are different methods to trace the pl/sql code?
What is union and union all keyword in sql and what are their differences?
What's the difference between a primary key and a clustered index?
What is sql injection vulnerability?
What does pl sql stand for?
What has stored procedures in sql?
What is the reports view in oracle sql developer?
Is left join faster than inner join?
What is sql constant?
What is the difference between the sql*loader and import utilities? : aql loader
What is triggering circuit?
What is snowflake sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?