select
obj#,
procedure$,
overload#,
procedure#,
position#,
sequence#,
level#,
argument,
type#,
charsetid,
charsetform,
default#,
in_out,
properties,
length,
precision#,
scale,
radix,
deflength,
sys.dbms_metadata_util.long2varchar(deflength,
'SYS.ARGUMENT$',
'DEFAULT$',
rowid),
type_owner,
type_name,
type_subname,
type_linkname,
pls_type
from sys.argument$
SELECT
OBJ#
,
PROCEDURE$
,
OVERLOAD#
,
PROCEDURE#
,
POSITION#
,
SEQUENCE#
,
LEVEL#
,
ARGUMENT
,
TYPE#
,
CHARSETID
,
CHARSETFORM
,
DEFAULT#
,
IN_OUT
,
PROPERTIES
,
LENGTH
,
PRECISION#
,
SCALE
,
RADIX
,
DEFLENGTH
,
SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(DEFLENGTH
,
'SYS.ARGUMENT$'
,
'DEFAULT$'
,
ROWID)
,
TYPE_OWNER
,
TYPE_NAME
,
TYPE_SUBNAME
,
TYPE_LINKNAME
,
PLS_TYPE
FROM SYS.ARGUMENT$
|
|
|