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


TABLE: ORDSYS.ORDDCM_RT_PREF_PARAMS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_PREF_PARAMS_PK1
  1. ColumnPPID
Unique Key: ORDDCM_PREF_PARAMS_UK1
  1. ColumnNAME
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_PREF_PARAMS_PK1 NORMAL UNIQUE TablespaceSYSTEM ColumnPPID
ORDDCM_PREF_PARAMS_UK1 NORMAL UNIQUE TablespaceSYSTEM ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_RT_PREF_PARAMS ORDDCM_PREF_PARAMS_FK1 TableORDDCM_DOCS ORDDCM_RT_PREF_PARAMS DOC_ID
Columns
Name Datatype Length Mandatory Comments
PPID NUMBER (38) Yes
NAME VARCHAR2 (64) Yes
VALUE VARCHAR2 (1999) Yes
DOC_ID NUMBER (38) Yes
PARAM_DESC VARCHAR2 (1999)
Query Text

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


SELECT PPID
,      NAME
,      VALUE
,      DOC_ID
,      PARAM_DESC
FROM ORDSYS.ORDDCM_RT_PREF_PARAMS;

Dependencies

[top of page]

ORDSYS.ORDDCM_RT_PREF_PARAMS does not reference any database object

ORDSYS.ORDDCM_RT_PREF_PARAMS is not referenced by any database object