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
List the various privileges that a user can grant to another user?
How can you save or place your msg in a table?
Is progress software supports to ( pl/sql )?
Can we create view in stored procedure?
How do I make my sql query run faster?
Can two tables have same primary key?
What is output spooling in sql*plus?
How is a PL/SQL code compiled?
What is count * in sql?
Which is faster subquery or join?
What is sql server and ase?
What is a column in a table?
What is the sql case statement?
What are instead of triggers?
How delete a row in sql?
