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


TABLE: ORDSYS.ORDDCM_ANON_RULES

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_ANON_RULES_PK1
  1. ColumnDOC_ID
  2. ColumnRULE_TYPE_ID
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_ANON_RULES_PK1 NORMAL UNIQUE TablespaceSYSTEM ColumnDOC_ID
ColumnRULE_TYPE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_ANON_RULES ORDDCM_ANON_RULES_FK3 TableORDDCM_ANON_ACTION_TYPES ORDDCM_ANON_RULES ANON_ACTION_TYPE_ID
ORDDCM_ANON_RULES ORDDCM_ANON_RULES_FK2 TableORDDCM_ANON_RULE_TYPES ORDDCM_ANON_RULES RULE_TYPE_ID
ORDDCM_ANON_RULES ORDDCM_ANON_RULES_FK1 TableORDDCM_DOCS ORDDCM_ANON_RULES DOC_ID
Columns
Name Datatype Length Mandatory Comments
DOC_ID NUMBER (38) Yes
RULE_TYPE_ID NUMBER
Yes
ANON_ACTION_TYPE_ID NUMBER
Yes
ANON_VALUE VARCHAR2 (128)
Query Text

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


SELECT DOC_ID
,      RULE_TYPE_ID
,      ANON_ACTION_TYPE_ID
,      ANON_VALUE
FROM ORDSYS.ORDDCM_ANON_RULES;

Dependencies

[top of page]

ORDSYS.ORDDCM_ANON_RULES does not reference any database object

ORDSYS.ORDDCM_ANON_RULES is not referenced by any database object