Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_ARGUMENTS Arguments in object accessible to the user

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NUsername of the owner of the object
2OBJECT_NAMEVARCHAR230(null)YProcedure or function name
3PACKAGE_NAMEVARCHAR230(null)YPackage name
4OBJECT_IDNUMBER22(null)NObject number of the object
5OVERLOADVARCHAR240(null)YOverload unique identifier
6SUBPROGRAM_IDNUMBER22(null)YUnique sub-program Identifier
7ARGUMENT_NAMEVARCHAR230(null)YArgument name
8POSITIONNUMBER22(null)NPosition in argument list, or null for function return value
9SEQUENCENUMBER22(null)NArgument sequence, including all nesting levels
10DATA_LEVELNUMBER22(null)NNesting depth of argument for composite types
11DATA_TYPEVARCHAR230(null)YDatatype of the argument
12DEFAULTEDVARCHAR21(null)YIs the argument defaulted?
13DEFAULT_VALUELONG0(null)YDefault value for the argument
14DEFAULT_LENGTHNUMBER22(null)YLength of default value for the argument
15IN_OUTVARCHAR29(null)YArgument direction (IN, OUT, or IN/OUT)
16DATA_LENGTHNUMBER22(null)YLength of the column in bytes
17DATA_PRECISIONNUMBER22(null)YLength: decimal digits (NUMBER) or binary digits (FLOAT)
18DATA_SCALENUMBER22(null)YDigits to right of decimal point in a number
19RADIXNUMBER22(null)YArgument radix for a number
20CHARACTER_SET_NAMEVARCHAR244(null)YCharacter set name for the argument
21TYPE_OWNERVARCHAR230(null)YOwner name for the argument type in case of object types
22TYPE_NAMEVARCHAR230(null)YObject name for the argument type in case of object types
23TYPE_SUBNAMEVARCHAR230(null)YSubordinate object name for the argument type in case of object types
24TYPE_LINKVARCHAR2128(null)YDatabase link name for the argument type in case of object types
25PLS_TYPEVARCHAR230(null)YPL/SQL type name for numeric arguments
26CHAR_LENGTHNUMBER22(null)YCharacter limit for string datatypes
27CHAR_USEDVARCHAR21(null)YIs the byte limit (B) or char limit (C) official for this string?

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:17
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here