PL/SQL: Packages Cheat Sheet

Below is the syntax for creating PL/SQL package specification:

CREATE [OR REPLACE] PACKAGE package_name [ AUTHID { CURRENT_USER | DEFINER } ] { IS | AS }
Package Body
CREATE [OR REPLACE] PACKAGE BODY package_name { IS | AS }
Package elements
package_name.package_element

Leave a Reply

Your email address will not be published. Required fields are marked *