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

VIEW: SYS.CDB_TYPE_VERSIONS

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

Description of each type version in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the type
TYPE_NAME VARCHAR2 (30) Yes Name of the type
VERSION# NUMBER
Yes Internal version number of the type
TYPECODE VARCHAR2 (30)
Typecode of the type
STATUS VARCHAR2 (7)
Status of the type
LINE NUMBER
Yes Line number of the type's spec
TEXT VARCHAR2 (4000)
Text of the type's spec
HASHCODE RAW (17)
Hashcode of the type
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      TYPE_NAME
,      VERSION#
,      TYPECODE
,      STATUS
,      LINE
,      TEXT
,      HASHCODE
,      CON_ID
FROM SYS.CDB_TYPE_VERSIONS;

Dependencies

[top of page]

SYS.CDB_TYPE_VERSIONS does not reference any database object

SYS.CDB_TYPE_VERSIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_TYPE_VERSIONS