what is the cursor and use of cursor in pl/sql ?
Answers were Sorted based on User's Feedback
Answer / prince pradeep
cursor is a handle or a pointer to a context area;
(context area is a memory area where sql statements are processed)
cursors are used to retrieve multiple records from data base
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / udaykumar
cursor is a private workspace memory,it does'nt stored in
the database.It is a buffer.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kesav
A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.
| Is This Answer Correct ? | 0 Yes | 0 No |
How delete a row in sql?
Write a unique difference between a function and a stored procedure.
How can I change database name in sql?
What is a mutating table
how many values can the set function of mysql take? : Sql dba
what is a sub query?how will you calculate working days in a month using sub query?
What is posting?
how to use like conditions? : Sql dba
How many sql core licenses do I need?
what is the difference between implicit and explicit trigger
what are the advantages of package?
How to convert comma separated string to array in pl/sql?
Oracle (3253)
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)