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 are sql functions? Describe the different types of sql functions?
Compare sql & pl/sql
What are the types of records?
Is inner join same as self join?
What are actual parameters and formal parameters?
Where not exists in sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Which are sql * plus commands?
What are synonyms in sql?
What is the maximum database size for sql express?
What is trigger explain with example?
How to write a query to show the details of a student from students table whose
What is PL/SQL Records?
Which is faster view or stored procedure?
When you have to use a default "rollback to" savepoint of plvlog?