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
How to handle bulk data?
How do I find duplicates in a single column in sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
what is self join and what is the requirement of self join? : Sql dba
What is vector point function?
What is sql procedures and functions?
What is lookup table in sql?
Mention what pl/sql package consists of?
How do I sort a table in sql?
Can you call pl/sql package functions from within a fast formula?
What are the differences between in and exists clause?
What is write ahead logging in sql server?
What is a common use of group by in sql?
What is an alias command?
Do stored procedures prevent sql injection?