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 |
What are the types of database lock?
When a form is invoked with CALL_FORM does Oracle forms issues?
What are data modelling tools?
What do you understand by query optimization?
What are the advantages of manual database?
how to restore particular schema from rman full backup?
Explain what is a deadlock and mention how it can be resolved?
What are the characteristics of database management system?
In which phase of mload can I use .filler?
What is big data in database?
What do you understand by sub-queries in sql?
i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in
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)