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
When to use inner join and left join?
what is a control file ? : Sql dba
Is nosql faster than sql?
How do I count rows in sql?
What are the types of records?
What is java sql driver?
how to dump a table to a file with 'mysqldump'? : Sql dba
Can we perform dml in function?
Which join condition can be specified using on clause?
What is trigger in sql? Explain
What is varchar data type in sql?
how does a local variable is defined using t-sql? : Transact sql
What is a design view?
What is varray in pl sql?
What are predefined functions in sql?
