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
Can a varchar be a primary key?
What is snowflake sql?
Can you have more than one key in a database?
What are views in sql?
What is trigger point?
What is coalesce sql?
What is the order of sql select?
How do you break a loop in pl sql?
How do you optimize a stored procedure query?
What are the parts of a sql statement?
What is primary key and unique key?
what is the difference between blob and text? : Sql dba
how to use myisamchk to check or repair myisam tables? : Sql dba
Why do we go for stored procedures?
How do you update sql?
