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 trigger price?
Can we commit inside a trigger?
Is sql easier than java?
What types of commands can be executed in sql*plus?
discuss about myisam key cache. : Sql dba
Write a query to display the current date in sql?
How delete all data from all tables in sql?
What does t sql mean?
how can you create an empty table from an existing table? : Sql dba
What does trigger mean in slang?
What is the difference between jpql and sql?
What are the types of subqueries?
how to use regular expression in pattern match conditions? : Sql dba
How do I view a sql database?
What is the use of function in sql?