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

Explain what is sql?

0 Answers  


What are sql indexes?

0 Answers  


What is the Subquery?

4 Answers  


How do I view output in sql developer?

0 Answers  


How to create a view on a table which does not exists

4 Answers   Oracle, TCS,






Is hadoop a nosql?

0 Answers  


What is a trigger in pl/sql?

1 Answers  


how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  


What is error ora-01000: maximum open cursors exceeded

0 Answers  


What is an example of translating a date into julian format?

0 Answers  


What is trigger in sql and its types?

0 Answers  


how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,


Categories