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


VIEW: CTXSYS.CTX_OBJECT_ATTRIBUTES

Object Details
Object Name: CTX_OBJECT_ATTRIBUTES
Object Type: VIEW
Owner: CTXSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OAT_CLASS VARCHAR2 (30)
OAT_OBJECT VARCHAR2 (30)
OAT_ATTRIBUTE VARCHAR2 (30)
OAT_DESCRIPTION VARCHAR2 (80)
OAT_REQUIRED CHAR (1)
OAT_STATIC CHAR (1)
OAT_DATATYPE VARCHAR2 (9)
OAT_DEFAULT VARCHAR2 (500)
OAT_MIN NUMBER

OAT_MAX VARCHAR2 (40)
OAT_MAX_LENGTH NUMBER

Query Text

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


SELECT OAT_CLASS
,      OAT_OBJECT
,      OAT_ATTRIBUTE
,      OAT_DESCRIPTION
,      OAT_REQUIRED
,      OAT_STATIC
,      OAT_DATATYPE
,      OAT_DEFAULT
,      OAT_MIN
,      OAT_MAX
,      OAT_MAX_LENGTH
FROM CTXSYS.CTX_OBJECT_ATTRIBUTES;

Dependencies

[top of page]

CTXSYS.CTX_OBJECT_ATTRIBUTES references the following:

SchemaCTXSYS
TableDR$CLASS
TableDR$OBJECT
TableDR$OBJECT_ATTRIBUTE
CTXSYS.CTX_OBJECT_ATTRIBUTES is referenced by following:

SchemaPUBLIC
SynonymCTX_OBJECT_ATTRIBUTES