Answer Posted / sachin fulari
To add upon
-----------
REF CURSOR is data type in Oracle, and to mention it as
dynamic cursor is totally erroneous.
We can declare variables of type REF CURSOR in declartion
section and which later on can associate with different
queries in execution section.
Moreover, we can also pass query as argument to procedures
using such data type.
( To easily understand REF CURSOR data type:
Visualize as if we are declaring a scalar data type like
NUMBER or CHAR and then utilizing it in execution
section.)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain how to use transactions efficiently : transact sql
What is a boolean in sql?
how to select first 5 records from a table? : Sql dba
Does oracle roll back the transaction on an error?
How many joins in sql?
How to avoid using cursors?
How do you rank data in sql?
What is sql and also describe types of sql statements?
What are the operators in sql?
What is optimistic concurrency control? : Transact sql
What are the ddl commands?
What does dml mean?
What is the use of function in sql?
What is trigger in pl sql with examples?
What are some emotional triggers?
