PL/SQL - Package

About

A package in PLSQL is an unit of code that declares:

• its API (ie all public objects such as variable, function, procedure) in the package specification
• its private API and the implementation of the public object in its body

Articles Related

Constant

CREATE OR REPLACE PACKAGE body pc_myPackage
IS

    constantName constant VARCHAR2(30) := 'Hello World';

...

Query

select * from user_objects where object_type = 'PACKAGE';
select * from all_objects where object_type = 'PACKAGE';