what is a cursor

Answer Posted / ganesh

cursor is a small work area like memory which are given by
oracle to execute sql statement, after execution this space
are made free for another sql staments to execute.

when we use the cursor with cursor name for a tble,then
that cursor will bring those from database one by one and
will keep in cursor memory for execution.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle bulk data?

900


How do I find duplicates in a single column in sql?

542


The select into statement is most often used to create backup copies of tables or for archiving records?

571


what is self join and what is the requirement of self join? : Sql dba

692


What is vector point function?

577






What is sql procedures and functions?

539


What is lookup table in sql?

611


Mention what pl/sql package consists of?

547


How do I sort a table in sql?

605


Can you call pl/sql package functions from within a fast formula?

578


What are the differences between in and exists clause?

578


What is write ahead logging in sql server?

572


What is a common use of group by in sql?

599


What is an alias command?

582


Do stored procedures prevent sql injection?

558