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
What is a relationship and what are they?
Is it possible to pass parameters to triggers?
Why partition by is used in sql?
What does count (*) do in sql?
describe mysql connection using mysql binary. : Sql dba
What are the different ways to optimize a sql query?
What is the use of & in pl sql?
What is using in sql?
Does execute immediate commit?
what is data integrity? : Sql dba
Do we need to create index on primary key?
How do I delete a trigger?
What is package in pl sql with an examples?
How to use boolean type in select statement?
What are the different types of dbms?
