OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
OBJECT_NAME |
VARCHAR2(30) |
|
Name of the procedure or function |
PACKAGE_NAME |
VARCHAR2(30) |
|
Name of the procedure or function |
OBJECT_ID |
NUMBER |
NOT NULL |
Object number of the object |
OVERLOAD |
VARCHAR2(40) |
|
Overload unique identifier |
ARGUMENT_NAME |
VARCHAR2(30) |
|
Name of the argument |
POSITION |
NUMBER |
NOT NULL |
Position in the argument list, or null for a function return value |
SEQUENCE |
NUMBER |
NOT NULL |
Argument sequence, including all nesting levels |
DATA_LEVEL |
NUMBER |
NOT NULL |
Nesting depth of the argument for composite types |
DATA_TYPE |
VARCHAR2(30) |
|
Datatype of the argument |
DEFAULT_VALUE |
LONG |
|
Reserved for future use |
DEFAULT_LENGTH |
NUMBER |
|
Reserved for future use |
IN_OUT |
VARCHAR2(9) |
|
Direction of the argument:
|
DATA_LENGTH |
NUMBER |
|
Length of the column (in bytes) |
DATA_PRECISION |
NUMBER |
|
Length in decimal digits (NUMBER ) or binary digits (FLOAT ) |
DATA_SCALE |
NUMBER |
|
Digits to the right of the 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(30) |
|
Owner of the type of the argument |
TYPE_NAME |
VARCHAR2(30) |
|
Name of the type of the argument. If the type is a package local type (that is, it is declared in a package specification), then this column displays the name of the package. |
TYPE_SUBNAME |
VARCHAR2(30) |
|
Relevant only for package local types. Displays the name of the type declared in the package identified in the TYPE_NAME column. |
TYPE_LINK |
VARCHAR2(128) |
|
Relevant only for package local types when the package identified in the TYPE_NAME column is a remote package. This column displays the database link used to refer to the remote package. |
PLS_TYPE |
VARCHAR2(30) |
|
For numeric arguments, the name of the PL/SQL type of the argument. Null otherwise. |
CHAR_LENGTH |
NUMBER |
|
Character limit for string datatypes |
CHAR_USED |
VARCHAR2(1) |
|
Indicates whether the byte limit (B ) or char limit (C ) is official for the string |