[Home] [Help] [Dependency Information]
Object Name: | DR$OBJECT_ATTRIBUTE |
---|---|
Object Type: | TABLE |
Owner: | CTXSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | CTXD |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
DRC$OAT_KEY | NORMAL | UNIQUE | CTXD | OAT_ID |
DRC$OAT_NAME | NORMAL | UNIQUE | CTXD |
OAT_CLA_ID
OAT_OBJ_ID OAT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OAT_ID | NUMBER | Yes | ||
OAT_CLA_ID | NUMBER | |||
OAT_OBJ_ID | NUMBER | |||
OAT_ATT_ID | NUMBER | |||
OAT_NAME | VARCHAR2 | (30) | ||
OAT_DESC | VARCHAR2 | (80) | ||
OAT_REQUIRED | CHAR | (1) | ||
OAT_SYSTEM | CHAR | (1) | ||
OAT_STATIC | CHAR | (1) | ||
OAT_DATATYPE | CHAR | (1) | ||
OAT_DEFAULT | VARCHAR2 | (500) | ||
OAT_VAL_MIN | NUMBER | |||
OAT_VAL_MAX | NUMBER | |||
OAT_LOV | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT OAT_ID
, OAT_CLA_ID
, OAT_OBJ_ID
, OAT_ATT_ID
, OAT_NAME
, OAT_DESC
, OAT_REQUIRED
, OAT_SYSTEM
, OAT_STATIC
, OAT_DATATYPE
, OAT_DEFAULT
, OAT_VAL_MIN
, OAT_VAL_MAX
, OAT_LOV
FROM CTXSYS.DR$OBJECT_ATTRIBUTE;
CTXSYS.DR$OBJECT_ATTRIBUTE does not reference any database object
CTXSYS.DR$OBJECT_ATTRIBUTE is referenced by following:
|
|
|