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 |
What will happen after commit statement ?
What is dialect in sql?
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
What does sql stand for?
What is lexical units in pl sql?
What is basic structure of pl sql?
What is procedure function?
what is 'mysqldump'? : Sql dba
What is the difference between null value, zero, and blank space?
What types of commands can be executed in sql*plus?
How to display Row Number with Records in Oracle SQL Plus?
What does dml mean?