|
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>
|