Answer Posted / t.r.sekhar
cursor is a temporary buffer used to hold the transactional
data for the manipulation purpose.
data will not permanently stored in database.
it is not reusable.
syntax:
cursor <cursor name> is <select stmt);
we have two types of cursors are there.
1.implicit cursors-automatically created whenever dml
statements are executed.
2.explicit cursors-created by user
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Explain spool.
What is embedded sql in db2?
What does count (*) do in sql?
Does pl sql work in mysql?
How global cursor can be declare with dynamic trigger ?
What is query optimization in sql?
what is online transaction processing (oltp)? : Sql dba
define sql delete statement ? : Sql dba
Can we join same table in sql?
How to connect a sql*plus session to an oracle server?
which operator is used in query for pattern matching? : Sql dba
What is group function in sql?
What is serial sql?
How does sql profiler work?
