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


Please Help Members By Posting Answers For Below Questions

what happens if you no create privilege in a database? : Sql dba

536


What is trigger price?

546


What is a database trigger?

616


What are the properties of a transaction?

573


Is pl sql a scripting language?

592






What is lexical units in pl sql?

580


Explain normalization and what are the advantages of it?

518


Which sql most popular?

567


What is sql partition?

558


I need a function for a train ticket reservation please answer it thanks in advance

567


What is data modelling in sql?

529


Which table is left in left join?

531


How can we implement rollback or commit statement in a trigger?

582


What is left join in postgresql?

544


How would you pass hints to the sql processor?

532