[Home] [Help]
[Dependency Information]
TABLE: ORDDATA.ORDDCM_DOCS_WRK
Object Details
Object Name: | ORDDCM_DOCS_WRK |
Object Type: | TABLE |
Owner: | ORDDATA |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 10 |
PCT Used: | 40 |
Primary Key: ORDDCM_DOCS_W_PK
- DOC_ID
Unique Key: ORDDCM_DOCS_W_UK1
- DOC_NAME
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
ORDDCM_DOCS_W_PK
|
NORMAL
|
UNIQUE
|
SYSTEM
|
DOC_ID
|
ORDDCM_DOCS_W_UK1
|
NORMAL
|
UNIQUE
|
SYSTEM
|
DOC_NAME
|
SYS_IL0000616635C00005$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
Foreign Keys
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
DOC_ID |
NUMBER |
|
Yes |
|
DOC_NAME |
VARCHAR2 |
(100) |
Yes |
|
DOC_TYPE_ID |
NUMBER |
|
Yes |
|
DOC_CONTENT |
XMLTYPE |
(2000) |
Yes |
|
ORACLE_INSTALL |
NUMBER |
(1) |
Yes |
|
CREATE_DATE |
DATE |
|
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT DOC_ID
, DOC_NAME
, DOC_TYPE_ID
, DOC_CONTENT
, ORACLE_INSTALL
, CREATE_DATE
FROM ORDDATA.ORDDCM_DOCS_WRK;
Dependencies
[top of page]
ORDDATA.ORDDCM_DOCS_WRK references the following:
-
SYS
-
STANDARD
- show dependent code
-
XMLTYPE
ORDDATA.ORDDCM_DOCS_WRK is referenced by following:
-
ORDSYS
-
ORD_DICOM_ADMIN_PRV
- show dependent code
-
ORD_DICOM_CT
- show dependent code