What is a cursor ? Why Cursor is required ?
Answers were Sorted based on User's Feedback
Answer / anil kumar jampana
cursor is a private sql area. pl/sql cann't handle multy
row select statements. Inorder to handle mulyrow select
statements, we are using cursors.
| Is This Answer Correct ? | 15 Yes | 2 No |
Cursor is a private memory area. to perform transations on
morethan one row we are using cursors. required multi-
records will be fetched to cursor area and will do
operations on those records. It is a temperary memory area.
Winthout Cursor pl/sql can perform only one record at a
time.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / suresh
cursor is private sql area. cursor is used for to retrieve
or display the more than one values at a time.
| Is This Answer Correct ? | 4 Yes | 1 No |
What does t sql mean?
What does partition by mean in sql?
What are the types of operators available in sql?
What are the subsets of sql?
How to fetch records from a partitioned table?
How do temporal tables work?
what are all different types of collation sensitivity? : Sql dba
What are different types of tables in sql?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
What is the difference between rename and alias?
What are instead of triggers?
How to convert comma separated string to array in pl/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)