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 is before and after trigger?
List the ways to get the count of records in a table?
What is dba in sql? : SQL DBA
what is isam? : Sql dba
How does rowid help in running a query faster?
What is numeric function sql?
What is user defined functions?
Does truncate table reset auto increment?
Can a foreign key have a different name?
What are the different ways to optimize a sql query?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is difference between cursor and trigger?
What are sql objects?
what is self-join? : Sql dba
What are the usages of sql?
