Oracle PL/SQL: PACKAGES: initialization - Package specifications can be used to initialize variables and define constants.

Quick Search:

Oracle PL/SQL: PACKAGES: initialization

Jump to:

Category: >> Oracle PL/SQL >> PACKAGES: initialization

<< last

next >>

Snippet Name: PACKAGES: initialization

Description: Package specifications can be used to initialize variables and define constants.

Also see:
» PACKAGES: related queries
» PACKAGES: alter package
» PACKAGES: overloading
» PACKAGES: one function
» PACKAGES: one procedure
» UTL_FILE file write to file example
» Create Package
» UTL_FILE import data

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

CREATE OR REPLACE PACKAGE init IS
g_var VARCHAR2(50);
FUNCTION dummy RETURN VARCHAR2;
END init_sect;
/
 
CREATE OR REPLACE PACKAGE BODY init IS
FUNCTION f_test1 RETURN VARCHAR2 IS
BEGIN
  RETURN g_var;
END f_test1;
BEGIN
  SELECT 'Harod Stassen'
  INTO g_var
  FROM dual; 
END init;
/