Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why do we use partitions in sql?
Why select is used in sql?
What are the sql versions?
How many disk partitions should I have?
What is sql basics?
What do you mean by dbms? What are its different types?
What is difference between stored function and application function?
Explain the the update statement in sql?
Does google use sql?
Can we have two clustered index on a table?
Why query optimization is needed?
Do we need to rebuild index after truncate?
What are the basic sql commands?
Is like operator in sql case sensitive?
What is nosql example?
