What cursor type do you use to retrieve multiple recordsets?
Answer Posted / venkat
using explict cursor we process multiple rows
syn:
cursor <cur_name> is select * from <tab_name>
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is difference between sql and mysql?
What is difference between sql and oracle?
Why is %isopen always false for an implicit cursor?
What is trigger in sql? Explain
What is the difference between sql and t sql?
What are the rules to be applied to nulls whilst doing comparisons?
What jobs use sql?
what happens if null values are involved in expressions? : Sql dba
Where can I learn sql for free?
what is 'mysqlimport'? : Sql dba
what is clause? : Sql dba
How do I start sql from command line?
What do you mean by table in sql?
Can a varchar be a primary key?