DBA Data[Home] [Help]

VIEW: SYS.KU$_ARGUMENT_VIEW

Source

View Text - Preformatted

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$
View Text - HTML Formatted

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$