After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
Oracle
»
PL-SQL
»
Coding
»
Packages
A package is a construct which bounds related procedures and functions together.
Variables declared in the declaration section of a package can be shared among the
procedures/functions in the body of the package.
/* package */
CREATE OR REPLACE PACKAGE INVPACK
IS
FUNCTION COUNTINV (SALESREP IN VARCHAR2) RETURN INTEGER;
PROCEDURE PURGEINV (INV_ID IN INTEGER) ;
END INVPACK;
/* package body */
CREATE OR REPLACE PACKAGE BODY INVPACK
IS
COUNT1 NUMBER;
FUNCTION COUNTINV (SALESREP IN VARCHAR2) RETURN INTEGER
IS
BEGIN
SELECT COUNT(*)
INTO COUNT1
FROM INVOICE
WHERE SALES_REP_ID = SALESREP ;
RETURN COUNT1 ;
END COUNTINV;
PROCEDURE PURGEINV (INV_ID1 IN INTEGER)
IS
BEGIN
DELETE FROM INVOICE
WHERE INV_ID = INV_ID1
END PURGEINV;
/* initialization section for package */
BEGIN
COUNT1 := 0 ;
END INVPACK;
|
|
|
|
