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
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Does sql*plus also have a pl/sql engine?
How can I delete duplicate rows?
How do you create a db file?
What is a column in a table?
Enlist some predefined exceptions?
Why is sql important?
What are different types of functions in sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
I need a function for a train ticket reservation please answer it thanks in advance
What is primary key secondary key alternate key candidate key?
What is oracle and pl sql?
What is procedure function?
Which sorts rows in sql?
how can we destroy the cookie? : Sql dba