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


TABLE: ORDSYS.ORDDCM_CT_PRED_OPRD

Object Details
Object Name: ORDDCM_CT_PRED_OPRD
Object Type: TABLE
Owner: ORDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: ORDDCM_CT_PO_PK
  1. ColumnPID
  2. ColumnPOS
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_CT_PO_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPID
ColumnPOS
SYS_IL0000488083C00004$$ LOB UNIQUE TablespaceSYSTEM
ORDDCM_CT_PO_PID_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnPID
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_CT_PRED_OPRD ORDDCM_CT_PO_FK TableORDDCM_CT_PRED ORDDCM_CT_PRED_OPRD PID
Columns
Name Datatype Length Mandatory Comments
PID NUMBER (38)
POS NUMBER (3)
OPERAND XMLTYPE (2000)
Query Text

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


SELECT PID
,      POS
,      OPERAND
FROM ORDSYS.ORDDCM_CT_PRED_OPRD;

Dependencies

[top of page]

ORDSYS.ORDDCM_CT_PRED_OPRD references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE

ORDSYS.ORDDCM_CT_PRED_OPRD is not referenced by any database object