Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_ARGUMENTS

Arguments in object accessible to the user

Columns
   ___________________________
 
   OBJECT_NAME
      Procedure or function name
   PACKAGE_NAME
      Package name
   OBJECT_ID
      Object number of the object
   OVERLOAD
      Overload unique identifier
   ARGUMENT_NAME
      Argument name
   POSITION
      Position in argument list,or null for function return value
   SEQUENCE
      Argument sequence,including all nesting levels
   DATA_LEVEL
      Nesting depth of argument for composite types
   DATA_TYPE
      Datatype of the argument
   DEFAULT_VALUE
      Default value for the argument
   DEFAULT_LENGTH
      Length of default value for the argument
   IN_OUT
      Argument direction (IN,OUT,or IN/OUT)
   DATA_LENGTH
      Length of the column in bytes
   DATA_PRECISION
      Length: decimal digits (NUMBER) or binary digits (FLOAT)
   DATA_SCALE
      Digits to right of decimal point in a number
   RADIX
      Argument radix for a number
   CHARACTER_SET_NAME
      Character set name for the argument
   TYPE_OWNER
      Owner name for the argument type in case of object types
   TYPE_NAME
      Object name for the argument type in case of object types
   TYPE_SUBNAME
      Subordinate object name for the argument type in case of object types
   TYPE_LINK
      Database link name for the argument type in case of object types
   PLS_TYPE
      PL/SQL type name for numeric arguments
   CHAR_LENGTH
      Character limit for string datatypes
   CHAR_USED
      Is the byte limit (B) or char limit (C) official for this string?

Related:



Simon Sheppard
SS64.com