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 should I use postgresql?
What are the indexing methods?
Can we use pl sql in sql server?
how to drop an existing table in mysql? : Sql dba
how to use case expression? : Sql dba
What packages(if any) has oracle provided for use by developers?
Can a foreign key have a different name?
How to run pl/sql statements in sql*plus?
what happens if you no create privilege in a database? : Sql dba
what is the difference between truncate and drop statements? : Sql dba
Name some usages of database trigger?
Can I create table without primary key?
How do you optimize a stored procedure query?
how to convert character strings to dates? : Sql dba
Is sql free?
