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 is the difference between clustered and non clustered index in sql? : Sql dba

558


Can you rollback after commit?

537


What is trigger in sql?

586


What type of database is sql?

621


How is pl sql different from sql?

557






what are all the different types of indexes? : Sql dba

542


What is application trigger?

552


Can a table contain multiple foreign key’s?

588


What does select count (*) mean in sql?

558


what is foreign key? : Sql dba

591


What is the difference between a subquery and a join?

537


What is the non-clustered index in sql?

596


how to include numeric values in sql statements? : Sql dba

571


What is the reports view in oracle sql developer?

553


What does the hierarchical profiler does?

579