[Home] [Help] [Dependency Information]
Object Name: | CDB_PLSQL_COLL_TYPES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of all named collection types in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Owner of the type | |
TYPE_NAME | VARCHAR2 | (128) | Name of the type | |
PACKAGE_NAME | VARCHAR2 | (30) | Name of the package containing the collection | |
COLL_TYPE | VARCHAR2 | (30) | Collection type | |
UPPER_BOUND | NUMBER | |||
ELEM_TYPE_OWNER | VARCHAR2 | (30) | Owner of the type of the element | |
ELEM_TYPE_NAME | VARCHAR2 | (136) | Name of the type of the element | |
ELEM_TYPE_PACKAGE | VARCHAR2 | (30) | 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) | Type modifier of the element | |
CON_ID | NUMBER | container id |
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
, INDEX_BY
, ELEM_TYPE_MOD
, CON_ID
FROM SYS.CDB_PLSQL_COLL_TYPES;
SYS.CDB_PLSQL_COLL_TYPES does not reference any database object
SYS.CDB_PLSQL_COLL_TYPES is referenced by following:
|
|
|