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
How do you optimize a stored procedure in sql?
What is the difference between rename and alias?
How do you update a table in sql?
What is exception? What are the types of exceptions?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
how many ways to get the current time? : Sql dba
What is difference between ms sql and mysql?
What are the different types of dbmss?
what is the use of set statement in tsql? : Transact sql
Which are the different character-manipulation functions in sql?
Is coalesce faster than isnull?
How do you use a while loop in pl sql?
Explain the savepoint statement.
What is the usage of sql functions?
How to display the current date in sql?