Listing 3: Drilling down into the details of ALL_ARGUMENTS

SQL> exec dd_view_scan ('all_arguments', '%')

Data Dictionary Views with columns like "ALL_ARGUMENTS.%"


> ALL_ARGUMENTS.OWNER

> ALL_ARGUMENTS.OBJECT_NAME
> ALL_ARGUMENTS.PACKAGE_NAME
> ALL_ARGUMENTS.OBJECT_ID

> ALL_ARGUMENTS.OVERLOAD
> ALL_ARGUMENTS.ARGUMENT_NAME
> ALL_ARGUMENTS.POSITION
> ALL_ARGUMENTS.SEQUENCE

> ALL_ARGUMENTS.DATA_LEVEL
> ALL_ARGUMENTS.DATA_TYPE
> ALL_ARGUMENTS.DEFAULT_VALUE
> ALL_ARGUMENTS.DEFAULT_LENGTH
> ALL_ARGUMENTS.IN_OUT

> ALL_ARGUMENTS.DATA_LENGTH
> ALL_ARGUMENTS.DATA_PRECISION
> ALL_ARGUMENTS.DATA_SCALE
> ALL_ARGUMENTS.RADIX
> ALL_ARGUMENTS.CHARACTER_SET_NAME
> ALL_ARGUMENTS.TYPE_OWNER

> ALL_ARGUMENTS.TYPE_NAME
> ALL_ARGUMENTS.TYPE_SUBNAME
> ALL_ARGUMENTS.TYPE_LINK
> ALL_ARGUMENTS.PLS_TYPE
> ALL_ARGUMENTS.CHAR_LENGTH
> ALL_ARGUMENTS.CHAR_USED