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 |
Explain what is sql?
What are sql indexes?
What is the Subquery?
How do I view output in sql developer?
How to create a view on a table which does not exists
Is hadoop a nosql?
What is a trigger in pl/sql?
how can we find the number of rows in a table using mysql? : Sql dba
What is error ora-01000: maximum open cursors exceeded
What is an example of translating a date into julian format?
What is trigger in sql and its types?
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,