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

VIEW: SYS.ALL_COLL_TYPES

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

Description of named collection types accessible to the user

[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?
CHAR_USED VARCHAR2 (1)
C if the width was specified in characters, B if in bytes
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
,      CHAR_USED
FROM SYS.ALL_COLL_TYPES;

Dependencies

[top of page]

SYS.ALL_COLL_TYPES references the following:

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

SchemaMDSYS
Package BodySDO_WFS_PROCESS - show dependent code
SchemaPUBLIC
SynonymALL_COLL_TYPES