Package

Package: procedure function package

PL / SQL stored procedures stored together with the relevant objects.

Create a package: header, including the body.

The establishment of Baotou

CREATE OR REPLACE PACKAGE emp_package IS

g_depno NUMBER (3): 30;

The PROCEDURE add_emp (eno number, name VARCHAR2);

Function get_sal (eno NUMBER) RETURN NUMBER;

The END EMP_PACKAGE;

The establishment of inclusions

CREATE OR REPLACE PACKAGE BODY emp_package

FUNCTION validata_comm (p_comm in number)

Return boolean;

v_max_comm NUMBER;

BEGIN

SELECT ……

……

END validata_comm is

The END emp_package;