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
Explain the difference between drop and truncate commands in sql?
Are null values same as that of zero or a blank space?
What is the difference between function, procedure and package in pl/sql?
When should I use nosql database?
how to decrement dates by 1 in mysql? : Sql dba
How do I make my sql query run faster?
What does pl sql developer do?
Which join condition can be specified using on clause?
Explain the significance of the & and && operators in pl sql.
How to start the command-line sql*plus?
Describe different types of general function used in sql?
What is a table partition?
What is minus?
What is the basic form of sql query?
Explain foreign key in sql?
