Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why having clause is used in sql?
What is rollback?
What is sqlcontext?
What is difference between stored function and application function?
Which is faster subquery or join?
What jobs use sql?
Are subqueries better than joins?
How to display Row Number with Records in Oracle SQL Plus?
What is embedded sql in db2?
what are aggregate and scalar functions? : Sql dba
What are predefined functions in sql?
What are the benefits of pl/sql packages?
What is dynamic query?
What is sql performance tuning?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
