Interested to Buy Any Domain ? << Click Here >> for more details...
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 does a pl/sql package consist of?
What are sql objects?
What is right join in sql?
How do I trace sql profiler?
Name the different types of indexes in sql and define them.
How to prepare for oracle pl sql certification?
What is meaning of <> in sql?
what are date and time data types? : Sql dba
Why select is used in sql?
What is the difference between python and sql?
What type of database is cloud sql?
What does inner join mean?
What is sql rowcount?
What is execute immediate?
What is sql table?
