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
How do I count rows in sql?
What is a temporal data type?
Can a foreign key be null?
Why is sql*loader direct path so fast?
What is meant by user defined function?
How to find 3rd highest salary of an employee from the employee table in sql?
What is a schema sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
Why do we need a foreign key?
Explain the purpose of %type and %rowtype data types with the example?
Can you upgrade sql express to full sql?
What is fmtonly in sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is a left join?
How are functions and procedures called in PL/SQL?