What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 67202 Views
- Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro, I also Faced
- E-Mail Answers
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
Explain mutating table error.
Can we use two order by clause in query?
What is composite data type in pl sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
Explain the difference between triggers and constraints?
What is sql key?
Does group by remove duplicates?
How does sql*loader handles newline characters in a record? : aql loader
What is a Mapplet?
What are the different set operators available in sql?
How can the performance of a trigger be improved?
What do you mean by rowid?
What are the types of sql commands?
Why do we need cursors in pl sql?
