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
What is java sql driver?
What is the difference between the implicit and explicit cursors?
Can we rollback truncate?
Explain clause in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is the use of partition by in sql?
What is audit logout in sql profiler?
Why is sql important?
How show all rows in sql?
How to get help at the sql prompt?
What are field types?
What is right join in sql?
What is difference between pls_integer and integer?
What is data type in sql?
What is sql server and ase?