Globals Stored in a Package : Packages « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Packages

SQL>
SQL>
SQL> create or replace package pkg_global is
  2     function f_countryUSA_cd return VARCHAR2;
  3  end;
  4  /

Package created.

SQL> create or replace package body pkg_global is
  2     gv_countryUSA_cd VARCHAR2(3) := 'USA';
  3
  4     function f_countryUSA_cd return VARCHAR2 is
  5     begin
  6        return gv_countryUSA_cd;
  7     end;
  8
  9  end;
 10  /

Package body created.

SQL>
SQL> select pkg_global.f_countryUSA_cd from dual;

F_COUNTRYUSA_CD
---------------------------------------------
USA

SQL>