[Home] [Help] [Dependency Information]
Object Name: | ORDDCM_CT_PRED_SET |
---|---|
Object Type: | TABLE |
Owner: | ORDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ORDDCM_CT_PS_PK | NORMAL | UNIQUE | SYSTEM | PSID |
ORDDCM_CT_PS_UQ | NORMAL | UNIQUE | SYSTEM |
NAME
PSTYPE SUPER |
ORDDCM_CT_PS_PID_IDX | NORMAL | NONUNIQUE | SYSTEM | PID |
ORDDCM_CT_PS_SPR_IDX | NORMAL | NONUNIQUE | SYSTEM | SUPER |
Table | |
Foreign Table | Foreign Key Column | ORDDCM_CT_PRED_SET | ORDDCM_CT_PRED | ORDDCM_CT_PRED_SET PID | ORDDCM_CT_PRED_SET | ORDDCM_CT_PRED_SET | ORDDCM_CT_PRED_SET SUPER | ORDDCM_CT_MACRO_PAR | ORDDCM_CT_PRED_SET | ORDDCM_CT_MACRO_PAR PSID | ORDDCM_CT_PRED_SET | ORDDCM_CT_PRED_SET | ORDDCM_CT_PRED_SET SUPER |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSID | NUMBER | (38) | Yes | |
NAME | VARCHAR2 | (64) | ||
PSTYPE | NUMBER | (1) | Yes | |
PID | NUMBER | (38) | ||
SUPER | NUMBER | (38) | ||
DESCRIPTION | VARCHAR2 | (1999) |
Cut, paste (and edit) the following text to query this object:
SELECT PSID
, NAME
, PSTYPE
, PID
, SUPER
, DESCRIPTION
FROM ORDSYS.ORDDCM_CT_PRED_SET;
ORDSYS.ORDDCM_CT_PRED_SET does not reference any database object
ORDSYS.ORDDCM_CT_PRED_SET is not referenced by any database object
|
|
|