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

VIEW: SYS.USER_PLSQL_COLL_TYPES

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

Description of the user's own named plsql collection types

[View Source]

Columns
Name Datatype Length Mandatory Comments
TYPE_NAME VARCHAR2 (128)
Name of the type
PACKAGE_NAME VARCHAR2 (128)
Name of the package containing the collection
COLL_TYPE VARCHAR2 (128)
Collection type
UPPER_BOUND NUMBER

The upper bound of a varray or length constraint of an index table type
ELEM_TYPE_OWNER VARCHAR2 (128)
Owner of the type of the element
ELEM_TYPE_NAME VARCHAR2 (136)
Name of the type of the element
ELEM_TYPE_PACKAGE VARCHAR2 (128)
Name of the package containing 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?
INDEX_BY VARCHAR2 (14)
Index by binary_integer or varchar2
ELEM_TYPE_MOD VARCHAR2 (7)
Query Text

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


SELECT TYPE_NAME
,      PACKAGE_NAME
,      COLL_TYPE
,      UPPER_BOUND
,      ELEM_TYPE_OWNER
,      ELEM_TYPE_NAME
,      ELEM_TYPE_PACKAGE
,      LENGTH
,      PRECISION
,      SCALE
,      CHARACTER_SET_NAME
,      ELEM_STORAGE
,      NULLS_STORED
,      INDEX_BY
,      ELEM_TYPE_MOD
FROM SYS.USER_PLSQL_COLL_TYPES;

Dependencies

[top of page]

SYS.USER_PLSQL_COLL_TYPES references the following:

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

SchemaPUBLIC
SynonymUSER_PLSQL_COLL_TYPES