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


TABLE: ORDSYS.ORDDCM_INSTALL_DOCS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_I_DOCS_PK
  1. ColumnDOC_NAME
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_I_DOCS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnDOC_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_INSTALL_DOCS ORDDCM_I_DOCS_FK2 TableORDDCM_DOC_TYPES ORDDCM_INSTALL_DOCS DOC_TYPE
ORDDCM_INSTALL_DOCS ORDDCM_I_DOCS_FK1 TableORDDCM_DOC_TYPES ORDDCM_INSTALL_DOCS DOC_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
DOC_TYPE_ID NUMBER
Yes
DOC_NAME VARCHAR2 (100) Yes
DOC_TYPE VARCHAR2 (100) Yes
Query Text

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


SELECT DOC_TYPE_ID
,      DOC_NAME
,      DOC_TYPE
FROM ORDSYS.ORDDCM_INSTALL_DOCS;

Dependencies

[top of page]

ORDSYS.ORDDCM_INSTALL_DOCS does not reference any database object

ORDSYS.ORDDCM_INSTALL_DOCS is not referenced by any database object