eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.ALL_PLSQL_COLL_TYPES

Object Details

Object Name:	ALL_PLSQL_COLL_TYPES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of named plsql collection types accessible to the user

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(128)	Owner of the type
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 by varchar2 table
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?
CHAR_USED	VARCHAR2	(1)	C if the width was specified in characters, B if in bytes
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 OWNER
,      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
,      CHAR_USED
,      INDEX_BY
,      ELEM_TYPE_MOD
FROM SYS.ALL_PLSQL_COLL_TYPES;

Dependencies

[top of page]

SYS.ALL_PLSQL_COLL_TYPES references the following:

SYS: COLLECTION$; OBJAUTH$; OID$; TYPE$; USER$; _CURRENT_EDITION_OBJ

SYS.ALL_PLSQL_COLL_TYPES is referenced by following:

PUBLIC: ALL_PLSQL_COLL_TYPES