DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.USER_COLL_TYPES

Object Details
Object Name: USER_COLL_TYPES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of the user's own named collection types

[View Source]

Columns
Name Datatype Length Mandatory Comments
TYPE_NAME VARCHAR2 (128) Yes Name of the type
COLL_TYPE VARCHAR2 (128) Yes Collection type
UPPER_BOUND NUMBER

Size of the FIXED ARRAY type or maximum size of the VARYING ARRAY type
ELEM_TYPE_MOD VARCHAR2 (7)
Type modifier of the element
ELEM_TYPE_OWNER VARCHAR2 (128)
Owner of the type of the element
ELEM_TYPE_NAME VARCHAR2 (128)
Name of the type of the element
LENGTH NUMBER

Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
PRECISION NUMBER

Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
SCALE NUMBER

Scale of the NUMBER or DECIMAL element
CHARACTER_SET_NAME VARCHAR2 (44)
Character set name of the element
ELEM_STORAGE VARCHAR2 (7)
Storage optimization specification for VARRAY of numeric elements
NULLS_STORED VARCHAR2 (3)
Is null information stored with each VARRAY element?
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TYPE_NAME
,      COLL_TYPE
,      UPPER_BOUND
,      ELEM_TYPE_MOD
,      ELEM_TYPE_OWNER
,      ELEM_TYPE_NAME
,      LENGTH
,      PRECISION
,      SCALE
,      CHARACTER_SET_NAME
,      ELEM_STORAGE
,      NULLS_STORED
FROM SYS.USER_COLL_TYPES;

Dependencies

[top of page]

SYS.USER_COLL_TYPES references the following:

SchemaSYS
TableCOLLECTION$
TableTYPE$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.USER_COLL_TYPES is referenced by following:

SchemaPUBLIC
SynonymUSER_COLL_TYPES