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

What will happen after commit statement ?

2 Answers  


What is dialect in sql?

0 Answers  


HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  


What does sql stand for?

0 Answers  


What is lexical units in pl sql?

0 Answers  






What is basic structure of pl sql?

0 Answers  


What is procedure function?

0 Answers  


what is 'mysqldump'? : Sql dba

0 Answers  


What is the difference between null value, zero, and blank space?

0 Answers  


What types of commands can be executed in sql*plus?

0 Answers  


How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,


What does dml mean?

0 Answers  


Categories