What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ?
Answer Posted / tulsi
A cursor declared in a package specification is global and
can be accessed by other procedures or procedures in a
package.
A cursor declared in a procedure is local to the procedure
that can not be accessed by other procedures.
| Is This Answer Correct ? | 40 Yes | 2 No |
Post New Answer View All Answers
how to use in conditions? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is the cause of mutating table error and how can we solve it?
is mysql query is case sensitive? : Sql dba
How do I remove sql developer from windows 10?
What is difference between pl and sql?
Is primary key is clustered index?
How to prepare for oracle pl sql certification?
What is a recursive stored procedure?
What is 19 null in sql?
Which is faster count (*) or count 1?
What is attribute indicator in pl sql?
When is the explicit cursor used ?
what tools available for managing mysql server? : Sql dba
Why we use triggers in mysql?