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
Which one is faster ienumerable or iqueryable?
How to Declare Fixed Length String Value In PL SQL
how to add a new column to an existing table in mysql? : Sql dba
What is aggregate function in sql?
How many joins can you have in sql?
Can we create table in function?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Which is the correct statement about truncate and delete?
How do you remove duplicates without using distinct in sql?
What is a temporal table?
Can we delete column in sql?
what is try_catch block in procedure
Why is nosql good?
What is the usage of when clause in trigger?
What is sqlcontext?