Answers

Question and Answer:

  Home  Oracle PL-SQL

⟩ What is difference between a Cursor declared in a procedure and Cursor declared in a package specification?

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.

 247 views

More Questions for you: