Search results
The CREATE PACKAGE statement creates or replaces the specification for a stored package, which is an encapsulated collection of related procedures, functions, and other program objects stored as a unit in the database.
- SQL Statements for Stored Pl/Sql Units
CREATE TRIGGER Statement. CREATE TYPE Statement. CREATE TYPE...
- Create Library Statement
For instructions for creating an operating-system shared...
- Description of The Illustration Create_Package.Eps
CREATE [ OR REPLACE ] [ EDITIONABLE | NONEDITIONABLE ]...
- Description of The Illustration Package_Function_Declaration.Eps
function_heading [ accessible_by_clause |...
- Description of Illustration Package_Procedure_Declaration
procedure_heading [accessible_by_clause] ; Copyright © 1996,...
- Description of The Illustration Plsql_Package_Source
[ schema. ] package_name [ sharing_clause ] [ {...
- SQL Statements for Stored Pl/Sql Units
Use the CREATE PACKAGE statement to create the specification for a stored package, which is an encapsulated collection of related procedures, functions, and other program objects stored together in the database.
What is a PL/SQL package. In PL/SQL, a package is a schema object that contains definitions for a group of related functionalities. A package includes variables, constants, cursors, exceptions, procedures, functions, and subprograms. It is compiled and stored in the Oracle Database.
PL/SQL package is a group of related functions, procedures, types, cursors, etc. PL/SQL package is like a library once written stored in the Oracle database and can be used by many applications. A PL/SQL package has two parts: package specification and package body.
This tutorial shows you step by step how to create a PL/SQL package specification by using the CREATE PACKAGE statement.
To create a package in Oracle PL/SQL, you first create the specification using the CREATE PACKAGE statement, and then you create the body using the CREATE PACKAGE BODY statement. Here’s an example:
This tutorial shows you step by step how to create a PL/SQL package body using the CREATE PACKAGE BODY statement.
