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 |
How do you optimize a query?
How will you delete a particular row from a Table?
Is it possible to read/write files to-and-from PL/SQL?
Why does %isopen return false for an implicit cursor?
Describe sql comments?
What are the difference between Functions/Stored Procs and Triggers and where are they used.
Mention what are different methods to trace the pl/sql code?
What does “select count(*) from tab” result?
15 Answers IBM, Student, Wipro,
Why cross join is used?
What is the difference between clustered and non-clustered index in sql?
What is cold data?
What is trigger in pl sql with examples?
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)