Answer Posted / joseph p v
2 Types
-Implicit Cursor
-Explicit Cursor
-Implicit Cursor
All select queries are examples of implicit cursor. While
submitting a select query , Oracle internally handle the
Open, fetch and close operations. Implicit Cursors are
using while query returns only row.
-Explicit Cursor
We want to explicitly define one cursor, open the cursor,
fetch and close the same. These type cursors are using
while the query return more than one row.
Ref Cursors are Cursors having the dynamic cursor statement
capabilities.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is foreign key in sql with example?
Difference between truncate, delete and drop commands?
explain about mysql and its features. : Sql dba
how to select first 5 records from a table? : Sql dba
What does seeding a database mean?
What is a temporal data type?
What does truncate mean in sql?
what is auto increment? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
Can we insert in view in sql?
Is sql pronounced sequel or sql?
Why do we go for stored procedures?
Explain the difference between triggers and constraints?
How do you clear the screen in sql?
Why do we create views in sql?
