[Home] [Help] [Dependency Information]

TABLE: MDSYS.SDO_COORD_OP_PARAM_VALS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORD_OP_PARA_VAL_PRIM

1. COORD_OP_ID
2. PARAMETER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORD_OP_PARA_VAL_PRIM	NORMAL	UNIQUE	SYSTEM	COORD_OP_ID PARAMETER_ID
SYS_IL0000385433C00006$$	LOB	UNIQUE	SYSTEM
SYS_IL0000385433C00008$$	LOB	UNIQUE	SYSTEM

Foreign Keys

Table		Foreign Table	Foreign Key Column
SDO_COORD_OP_PARAM_VALS		SDO_COORD_OPS	SDO_COORD_OP_PARAM_VALS COORD_OP_ID
SDO_COORD_OP_PARAM_VALS		SDO_COORD_OP_METHODS	SDO_COORD_OP_PARAM_VALS COORD_OP_METHOD_ID
SDO_COORD_OP_PARAM_VALS		SDO_COORD_OP_PARAMS	SDO_COORD_OP_PARAM_VALS PARAMETER_ID
SDO_COORD_OP_PARAM_VALS		SDO_UNITS_OF_MEASURE	SDO_COORD_OP_PARAM_VALS UOM_ID

Columns

Query Text

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

SELECT COORD_OP_ID
,      COORD_OP_METHOD_ID
,      PARAMETER_ID
,      PARAMETER_VALUE
,      PARAM_VALUE_FILE_REF
,      PARAM_VALUE_FILE
,      PARAM_VALUE_XML
,      UOM_ID
FROM MDSYS.SDO_COORD_OP_PARAM_VALS;

Dependencies

[top of page]

PUBLIC

XMLTYPE

SYS

STANDARD - show dependent code

XMLTYPE

MDSYS

SDO_COORD_OP_PARAM_VAL_TRIGG2

SDO_COORD_OP_PARAM_VAL_TRIGGER

SDO_CS - show dependent code

PUBLIC

SDO_COORD_OP_PARAM_VALS