Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_COLL_TYPES Description of named collection types accessible to the user

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NOwner of the type
2TYPE_NAMEVARCHAR230(null)NName of the type
3COLL_TYPEVARCHAR230(null)NCollection type
4UPPER_BOUNDNUMBER22(null)YSize of the FIXED ARRAY type or maximum size of the VARYING ARRAY type
5ELEM_TYPE_MODVARCHAR27(null)YType modifier of the element
6ELEM_TYPE_OWNERVARCHAR230(null)YOwner of the type of the element
7ELEM_TYPE_NAMEVARCHAR230(null)YName of the type of the element
8LENGTHNUMBER22(null)YLength of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
9PRECISIONNUMBER22(null)YDecimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
10SCALENUMBER22(null)YScale of the NUMBER or DECIMAL element
11CHARACTER_SET_NAMEVARCHAR244(null)YCharacter set name of the element
12ELEM_STORAGEVARCHAR27(null)YStorage optimization specification for VARRAY of numeric elements
13NULLS_STOREDVARCHAR23(null)YIs null information stored with each VARRAY element?

Index | Home | Forums

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