[Home] [Help] [Dependency Information]
Object Name: | COLLECTION$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 0 |
PCT Used: | 0 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_COLLECTION1 | NORMAL | UNIQUE | SYSTEM |
TOID
VERSION# PACKAGE_OBJ# |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TOID | RAW | (16) | Yes | |
VERSION# | NUMBER | Yes | ||
COLL_TOID | RAW | (16) | Yes | |
COLL_VERSION# | NUMBER | Yes | ||
ELEM_TOID | RAW | (16) | Yes | |
ELEM_VERSION# | NUMBER | Yes | ||
PROPERTIES | NUMBER | Yes | ||
CHARSETID | NUMBER | |||
CHARSETFORM | NUMBER | |||
LENGTH | NUMBER | |||
PRECISION | NUMBER | |||
SCALE | NUMBER | |||
UPPER_BOUND | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SYNOBJ# | NUMBER | |||
COLL_NAME | VARCHAR2 | (128) | ||
PACKAGE_OBJ# | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TOID
, VERSION#
, COLL_TOID
, COLL_VERSION#
, ELEM_TOID
, ELEM_VERSION#
, PROPERTIES
, CHARSETID
, CHARSETFORM
, LENGTH
, PRECISION
, SCALE
, UPPER_BOUND
, SPARE1
, SPARE2
, SPARE3
, SYNOBJ#
, COLL_NAME
, PACKAGE_OBJ#
FROM SYS.COLLECTION$;
SYS.COLLECTION$ does not reference any database object
SYS.COLLECTION$ is referenced by following:
|
|
|