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 asqueryable?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How long does it take to learn pl sql?
How to sort the rows in sql.
what are the advantages and disadvantages of cascading style sheets? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
how many columns can be used for creating index? : Sql dba
how to calculate expressions with sql statements? : Sql dba
What are joins in sql?
How to combine two stored procedures in sql?
What is left join example?
Is join an inner join?
What schema means?
Is sql similar to python?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
