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 single byte over head in oracle..?
What are expressions?
What is the command used to fetch first 5 characters of the string?
What are three advantages to using sql?
Explain locks? : Transact sql
what is online transaction processing (oltp)? : Sql dba
Can we use view in stored procedure?
What are keys in sql?
What is the basic form of sql query?
Is a table valued function object?
Which sql statement is used to delete data from a database?
what is not null constraint? : Sql dba
how to do backup entire database? : Transact sql
What is the difference between syntax error and runtime error?
What is sql query optimization?