Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ?
- 2 Answers
- 16519 Views
- JDA, I also Faced
- E-Mail Answers
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
Why is %isopen always false for an implicit cursor?
Can we create view in stored procedure?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What are the two types of periodical indexes?
What does rownum mean in sql?
What are the qualities of 2nf?
Explain the the update statement in sql?
What is a mutating table and a constraining table?
What is sqlexception in java?
What is rtm in testing?
Explain polymorphism in pl/sql.
What is a unique constraint?
which types of join is used in sql widely? : Sql dba
What is sql*loader and what is it used for?
describe transaction-safe table types in mysql : sql dba
