Oracle 21c の PACKAGE ソースを確認する

環境

OS：Windows 11 Home 64 ビット オペレーティング システム
CPU：11th Gen Intel(R) Core(TM) i7-1185G7 @ 3.00GHz 3.00 GHz
RAM：32.0 GB
DB：Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

https://localhost:5500/em/shell

パッケージ仕様部のソース確認

実行例

SQL> select OWNER, NAME, TYPE, LINE, TEXT from ALL_SOURCE where TYPE = 'PACKAGE' and NAME = 'OWA_UTIL' order by LINE;

実行結果

OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
SYS
OWA_UTIL
PACKAGE                           1
package OWA_UTIL AUTHID CURRENT_USER


OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
SYS
OWA_UTIL
PACKAGE                           2
is

（中略）

OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
;

SYS
OWA_UTIL
PACKAGE                         445

OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------


SYS
OWA_UTIL
PACKAGE                         446

OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
end;


446行が選択されました。

パッケージ本体のソース確認

実行例

SQL> select OWNER, NAME, TYPE, LINE, TEXT from ALL_SOURCE where TYPE = 'PACKAGE BODY' and NAME = 'OWA_UTIL' order by LINE;

実行結果

OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
SYS
OWA_UTIL
PACKAGE BODY                      1
package body OWA_UTIL is


OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
SYS
OWA_UTIL
PACKAGE BODY                      2



OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
SYS
OWA_UTIL
PACKAGE BODY                      3
   owa_version CONSTANT varchar2(64) := '20.0.0.0.1';

（中略）

OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                           LINE
------------------------ ----------
TEXT
--------------------------------------------------------------------------------
PACKAGE BODY                   2478
end;


2478行が選択されました。