What is cursor and where do you use them?
Answers were Sorted based on User's Feedback
Cursor is an named private area called active set which is
used to process the multiple rows returned by the query....
cursors are mainly used in procedure/package/function when
the select qurey in procedure/package/function returns
more than one value....
if their is any issue mail me @
rajesh_natesh@yahoo.com,rajesh.natesh@cognizant.com
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / guest
cursor is temperory block of memory which holds the data as
temperory in buffer
| Is This Answer Correct ? | 1 Yes | 3 No |
Explain the key constraints and constraints on Null Values with examples?
How to activate all indexes in firebird?
How many types of data are there?
Explain what are service-specific middleware?
What are database modules?
What do you understand by data independence? What are its two types?
When is functional dependency said to be the fully functional dependency?
Explain about cursors?
What is a concurrency problem in dbms?
Briefly describe the three types of sql commands.
When we will denormalize data?
Define dbms.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)