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 |
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
What are the types of join in sql?
What is dml with example?
How does left join work in sql?
What is difference between primary and secondary key?
How can you fetch first 5 characters of the string?
how to convert dates to character strings? : Sql dba
How delete all data from table in sql?
what is the difference between join and union? : Sql dba
What are the popular database management systems in the it industry?
What's the procedure?
What is dynamic SQl and how you will create and execute dynamic sql?
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)