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
what are date and time data types? : Sql dba
How can use stored procedures in sql?
What is bind reference and how can it be created?
What are the benefits of stored procedures?
Does truncate free space?
Why are cursors used?
What is sap sql?
How can you know that statistics should be updated?
What is normalization in sql?
What is a nested table in word?
What are the different types of a subquery?
When do we use triggers?
how to analyze tables with 'mysqlcheck'? : Sql dba
how to shutdown mysql server? : Sql dba
What does partition by mean in sql?