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 is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are the built in functions of sql?
What are the benefits of pl sql?
How to return an array from java to pl/sql?
What are the benefits of pl/sql packages?
Why do we use view in sql?
What is difference between left and right outer join?
what is schema? : Sql dba
How many joins can you have in sql?
Explain what is a field in a database and record in a database?
How many commands are in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How to add, remove, modify users using sql?
how many ways to get the current time? : Sql dba
What is sql in oracle?
