What are cursors? Explain different types of cursors?
Answer Posted / ramesh
Implicit Cursors --Occurs on behalf of every sql statement
Explicit Cursors --Named Cursors used in Plsql
Paramaeteried Cursors --Pass Paramters to a Named Cursor
Cheers,
Ramesh
Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
Explain about normal forms?
What is a database development?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
In which table collections errors are stored.
What are the types of database model?
How to use online Backups?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
What are the three types of database design?
Can an extended stored procedure be called from inside a user-defined function?
Write short notes on manual refreshes.
Explain about a primary key?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
State the acid rules?
How to use timestamp datatypes