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

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';

Powered by ComboStrap