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

VIEW: SYS.DBA_COLL_TYPES

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

Description of all named collection types in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the type
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 OWNER
,      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.DBA_COLL_TYPES;

Dependencies

[top of page]

SYS.DBA_COLL_TYPES references the following:

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

SchemaAPPS
Package BodyETRM_PNAV - show dependent code
SchemaPUBLIC
SynonymDBA_COLL_TYPES