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
What is pivot query?
How do you update a sql procedure?
What is the difference among union, minus and intersect?
Which is faster union or join?
What are the two characteristics of a primary key?
What is the difference between jpql and sql?
What is an index in sql with example?
What is the source code of a program?
Can you do multiple joins in sql?
What are the datatypes available in pl/sql ?
What is a natural join sql?
What is $$ in sql?
How many types of functions are there in sql?
What is the basic form of sql query?
What are the different dml commands in sql?
