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 cross join example?
Explian rowid, rownum?
What does pl sql stand for?
What is program debugging?
What is a pl/sql block?
Does sql profiler affect performance?
what is the difference between inner and outer join? Explain with example. : Sql dba
Why procedure is used in sql?
what is log shipping? : Sql dba
Are left and right joins the same?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is java sql connection?
What operating systems are supported by oracle sql developer?
What are % type and % rowtype?
how to do backup entire database? : Transact sql