What is a cursor ? Why Cursor is required ?

Answers were Sorted based on User's Feedback



What is a cursor ? Why Cursor is required ?..

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

What is a cursor ? Why Cursor is required ?..

Answer / raam

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

What is a cursor ? Why Cursor is required ?..

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

Post New Answer

More SQL PLSQL Interview Questions

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,


Do we need to create index on primary key?

0 Answers  


Why sql query is slow?

0 Answers  


What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  


what is unique key constraint? : Sql dba

0 Answers  


How to get second highest salary from a table

3 Answers  


What is sql injection owasp?

0 Answers  


Does oracle roll back the transaction on an error?

0 Answers  


How many indexes can be created on a table in sql?

0 Answers  


What are the two virtual tables available at the time of database trigger execution?

0 Answers  


How do I upgrade sql?

0 Answers  


How many sql core licenses do I need?

0 Answers  


Categories