Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_ARGUMENTS

Arguments in object accessible to the user

Columns
   ___________________________
 
   DATA_PRECISION
      Length: decimal digits (NUMBER) or binary digits (FLOAT)
   TYPE_OWNER
      Owner name for the argument type in case of object types
   RADIX
      Argument radix for a number
   CHARACTER_SET_NAME
      Character set name for the argument
   DATA_SCALE
      Digits to right of decimal point in a number
   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
   PLS_TYPE
      PL/SQL type name for numeric arguments
   DATA_LENGTH
      Length of the column in bytes
   PACKAGE_NAME
      Package name
   TYPE_LINK
      Database link name for the argument type in case of object types
   ARGUMENT_NAME
      Argument name
   OVERLOAD
      Overload unique identifier
   OBJECT_ID
      Object number of the object
   IN_OUT
      Argument direction (IN, OUT, or IN/OUT)
   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
   OBJECT_NAME
      Procedure or function name

Related Commands:




Back to the Top

Simon Sheppard
SS64.com