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

VIEW: SYS.CDB_SQLJ_TYPE_ATTRS

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

Description of attributes of all types in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
Owner of the type
TYPE_NAME VARCHAR2 (30) Yes Name of the type
ATTR_NAME VARCHAR2 (128) Yes Name of the attribute
EXTERNAL_ATTR_NAME VARCHAR2 (4000)
External name of the attribute
ATTR_TYPE_MOD VARCHAR2 (7)
Type modifier of the attribute
ATTR_TYPE_OWNER VARCHAR2 (30)
Owner of the type of the attribute
ATTR_TYPE_NAME VARCHAR2 (30)
Name of the type of the attribute
LENGTH NUMBER

Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
PRECISION NUMBER

Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
SCALE NUMBER

Scale of the NUMBER or DECIMAL attribute
CHARACTER_SET_NAME VARCHAR2 (44)
Character set name of the attribute
ATTR_NO NUMBER
Yes Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number)
INHERITED VARCHAR2 (3)
Is the attribute inherited from the supertype ?
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      TYPE_NAME
,      ATTR_NAME
,      EXTERNAL_ATTR_NAME
,      ATTR_TYPE_MOD
,      ATTR_TYPE_OWNER
,      ATTR_TYPE_NAME
,      LENGTH
,      PRECISION
,      SCALE
,      CHARACTER_SET_NAME
,      ATTR_NO
,      INHERITED
,      CON_ID
FROM SYS.CDB_SQLJ_TYPE_ATTRS;

Dependencies

[top of page]

SYS.CDB_SQLJ_TYPE_ATTRS does not reference any database object

SYS.CDB_SQLJ_TYPE_ATTRS is referenced by following:

SchemaPUBLIC
SynonymCDB_SQLJ_TYPE_ATTRS