Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suriya
Cursor is a mechanism by which we can name a 'select
stataments' and manipulate the information within that.
They are very useful, when we need to run a particular SQL
repeatedly.
Cursors are of 2 types, Implicit and Explicit.
Implicit Cursors: All the select statements we run are
implicitly stored in a cursor, by default. They are defined
by oracle.
Explicit Cursors: This is like user defined cursor. The
user can declare and use a cursor of his own requirement.
The operations performed with a cursor are declaring,
opening,fetching and closing.
Note:Leaving a cursor unclosed, will cause error.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the main difference between sql and pl/sql?
What is the life of an sql statement?
What are two statement types in sql?
Explain the insert into statements in sql?
What is the usage of sql functions?
What is int identity in sql?
What is mdb stand for?
What is the maximum database size for sql express?
what is the difference between myisam static and myisam dynamic? : Sql dba
How many commands are in sql?
Are stored procedures compiled?
How many types of primary keys are there?
i have some prob lem to tell me about my self in interview first round ...
What is a primary key called that is made up of more than one field?
How exception handling is done in advance pl/sql?
