[Home] [Help] [Dependency Information]
Object Name: | SDO_COORD_OP_PARAM_VALS |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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 |
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 |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COORD_OP_ID | NUMBER | (10) | Yes | |
COORD_OP_METHOD_ID | NUMBER | (10) | ||
PARAMETER_ID | NUMBER | (10) | Yes | |
PARAMETER_VALUE | FLOAT | (22) | ||
PARAM_VALUE_FILE_REF | VARCHAR2 | (254) | ||
PARAM_VALUE_FILE | CLOB | (4000) | ||
PARAM_VALUE_XML | XMLTYPE | (2000) | ||
UOM_ID | NUMBER | (10) |
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;
|
|
|