PL/SQL - Package

> Procedural Languages > PL/SQL - (Procedure Language|PL) SQL

1 - 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

3 - Constant

CREATE OR REPLACE PACKAGE BODY pc_myPackage
IS
 
    constantName CONSTANT VARCHAR2(30) := 'Hello World';
 
...

4 - Query

SELECT * FROM user_objects WHERE object_type = 'PACKAGE';
SELECT * FROM all_objects WHERE object_type = 'PACKAGE';
Advertising
lang/plsql/package.txt · Last modified: 2017/09/06 22:18 by gerardnico