[Home] [Help] [Dependency Information]
Object Name: | ALL_ARGUMENTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Arguments in object accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Username of the owner of the object |
OBJECT_NAME | VARCHAR2 | (128) | Procedure or function name | |
PACKAGE_NAME | VARCHAR2 | (128) | Package name | |
OBJECT_ID | NUMBER | Yes | Object number of the object | |
OVERLOAD | VARCHAR2 | (40) | Overload unique identifier | |
SUBPROGRAM_ID | NUMBER | Unique sub-program Identifier | ||
ARGUMENT_NAME | VARCHAR2 | (128) | Argument name | |
POSITION | NUMBER | Yes | Position in argument list, or null for function return value | |
SEQUENCE | NUMBER | Yes | Argument sequence, including all nesting levels | |
DATA_LEVEL | NUMBER | Yes | Nesting depth of argument for composite types | |
DATA_TYPE | VARCHAR2 | (30) | Datatype of the argument | |
DEFAULTED | VARCHAR2 | (1) | Is the argument defaulted? | |
DEFAULT_VALUE | LONG | (0) | Default value for the argument | |
DEFAULT_LENGTH | NUMBER | Length of default value for the argument | ||
IN_OUT | VARCHAR2 | (9) | Argument direction (IN, OUT, or IN/OUT) | |
DATA_LENGTH | NUMBER | Length of the column in bytes | ||
DATA_PRECISION | NUMBER | Length: decimal digits (NUMBER) or binary digits (FLOAT) | ||
DATA_SCALE | NUMBER | Digits to right of decimal point in a number | ||
RADIX | NUMBER | Argument radix for a number | ||
CHARACTER_SET_NAME | VARCHAR2 | (44) | Character set name for the argument | |
TYPE_OWNER | VARCHAR2 | (128) | Owner name for the argument type in case of object types | |
TYPE_NAME | VARCHAR2 | (128) | Object name for the argument type in case of object types | |
TYPE_SUBNAME | VARCHAR2 | (128) | Subordinate object name for the argument type in case of object types | |
TYPE_LINK | VARCHAR2 | (128) | Database link name for the argument type in case of object types | |
PLS_TYPE | VARCHAR2 | (128) | PL/SQL type name for numeric arguments | |
CHAR_LENGTH | NUMBER | Character limit for string datatypes | ||
CHAR_USED | VARCHAR2 | (1) | Is the byte limit (B) or char limit (C) official for this string? | |
ORIGIN_CON_ID | NUMBER | ID of Container where row originates |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, OBJECT_NAME
, PACKAGE_NAME
, OBJECT_ID
, OVERLOAD
, SUBPROGRAM_ID
, ARGUMENT_NAME
, POSITION
, SEQUENCE
, DATA_LEVEL
, DATA_TYPE
, DEFAULTED
, DEFAULT_VALUE
, DEFAULT_LENGTH
, IN_OUT
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, RADIX
, CHARACTER_SET_NAME
, TYPE_OWNER
, TYPE_NAME
, TYPE_SUBNAME
, TYPE_LINK
, PLS_TYPE
, CHAR_LENGTH
, CHAR_USED
, ORIGIN_CON_ID
FROM SYS.ALL_ARGUMENTS;
|
|
|