Explain what Is The Difference Between Private Package Construct And Public Package Construct?
Public package constructs are declared in the package specification but defined in the package body and can be invoked from any other object in the oracle environment.
Private package constructs are those that are declared and defined only within the package body. They are not declared in the package specification and can only be referenced by other constructs, which are part of the same package.
Private package construct is always defined before a public package construct within the package body.