What Is A Package And How Does It Differ From Procedure And Function?

1.	What Is A Package And How Does It Differ From Procedure And Function?
Answer» A package is a group of logically related PL/SQL SUBPROGRAMS BUNDLED together with PL/SQL types and other associated OBJECTS. It consists of the following two parts: Package specification —Includes declaration of all the objects and subprograms that are part of the package. Package body—Includes the total DEFINITION of all the parts of a package that have been declared in the specification. The whole package is fully loaded into the memory when any package construct is called for the first time. Therefore, it does not require any DISK input/output on later calls to constructs in the same package. A package is a group of logically related PL/SQL subprograms bundled together with PL/SQL types and other associated objects. It consists of the following two parts: The whole package is fully loaded into the memory when any package construct is called for the first time. Therefore, it does not require any disk input/output on later calls to constructs in the same package.

Answer»

A package is a group of logically related PL/SQL SUBPROGRAMS BUNDLED together with PL/SQL types and other associated OBJECTS. It consists of the following two parts:

Package specification —Includes declaration of all the objects and subprograms that are part of the package.
Package body—Includes the total DEFINITION of all the parts of a package that have been declared in the specification.

The whole package is fully loaded into the memory when any package construct is called for the first time. Therefore, it does not require any DISK input/output on later calls to constructs in the same package.

A package is a group of logically related PL/SQL subprograms bundled together with PL/SQL types and other associated objects. It consists of the following two parts:

The whole package is fully loaded into the memory when any package construct is called for the first time. Therefore, it does not require any disk input/output on later calls to constructs in the same package.

What Is A Package And How Does It Differ From Procedure And Function?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment