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
Is join and inner join the same?
What is the function that is used to transfer a pl/sql table log to a database table?
What are views in sql?
Can pl sql procedure have a return statement?
Does sql profiler affect performance?
what is error ora-03113: end-of-file on communication channel?
What is normalisation in sql?
Why do we use procedures in pl sql?
What is having clause in sql?
What can sql server reporting services do?
Which is better varchar or nvarchar?
What does a pl/sql package consist of?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is group function in sql?
What is difference between mysql and postgresql?