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


TABLE: ORDSYS.ORD_INSTALLATIONS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: PK_ORD_INSTALLATIONS
  1. ColumnSHORT_NAME
Indexes
Index Type Uniqueness Tablespace Column
PK_ORD_INSTALLATIONS NORMAL UNIQUE TablespaceSYSTEM ColumnSHORT_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableORD_CARTRIDGE_COMPONENTS FK_ORD_CARTRIDGE_COMPONENTS ORD_INSTALLATIONS ORD_CARTRIDGE_COMPONENTS SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
SHORT_NAME VARCHAR2 (30) Yes
NAME VARCHAR2 (1000) Yes
VERSION VARCHAR2 (30) Yes
DESCRIPTION VARCHAR2 (2000) Yes
INSTALLATION_STATUS VARCHAR2 (10) Yes
Query Text

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


SELECT SHORT_NAME
,      NAME
,      VERSION
,      DESCRIPTION
,      INSTALLATION_STATUS
FROM ORDSYS.ORD_INSTALLATIONS;

Dependencies

[top of page]

ORDSYS.ORD_INSTALLATIONS does not reference any database object

ORDSYS.ORD_INSTALLATIONS is not referenced by any database object