What Is Difference Between A Cursor Declared In A Procedure And Curso

1.	What Is Difference Between A Cursor Declared In A Procedure And Cursor Declared In A Package Specification ?
Answer» 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. 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.

What Is Difference Between A Cursor Declared In A Procedure And Cursor Declared In A Package Specification ?

Answer»

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.

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.