What cursor type do you use to retrieve multiple recordsets?

Answer Posted / guest

cursor <<cursorname>> is select * from <<table name>>

Is This Answer Correct ?    55 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you optimize a stored procedure in sql?

499


What is the difference between rename and alias?

705


How do you update a table in sql?

519


What is exception? What are the types of exceptions?

554


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

666






how many ways to get the current time? : Sql dba

526


What is difference between ms sql and mysql?

474


What are the different types of dbmss?

561


what is the use of set statement in tsql? : Transact sql

533


Which are the different character-manipulation functions in sql?

545


Is coalesce faster than isnull?

504


How do you use a while loop in pl sql?

534


Explain the savepoint statement.

597


What is the usage of sql functions?

541


How to display the current date in sql?

595