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 |
can we delete the trigger in a view? if yes why if not why?
Do we need to create index on primary key?
Why sql query is slow?
What is the difference between the sql*loader and import utilities? : aql loader
what is unique key constraint? : Sql dba
How to get second highest salary from a table
What is sql injection owasp?
Does oracle roll back the transaction on an error?
How many indexes can be created on a table in sql?
What are the two virtual tables available at the time of database trigger execution?
How do I upgrade sql?
How many sql core licenses do I need?