eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MDSYS.SDO_COORD_OP_PARAM_USE

Object Details

Object Name:	SDO_COORD_OP_PARAM_USE
Object Type:	TABLE
Owner:	MDSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORD_OP_PARA_USE_PRIM

COORD_OP_METHOD_ID
SORT_ORDER

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORD_OP_PARA_USE_PRIM	NORMAL	UNIQUE	SYSTEM	COORD_OP_METHOD_ID SORT_ORDER

Foreign Keys

Table		Foreign Table	Foreign Key Column
SDO_COORD_OP_PARAM_USE		SDO_COORD_OP_METHODS	SDO_COORD_OP_PARAM_USE COORD_OP_METHOD_ID
SDO_COORD_OP_PARAM_USE		SDO_COORD_OP_PARAMS	SDO_COORD_OP_PARAM_USE PARAMETER_ID

Columns

Name	Datatype	Length	Mandatory
COORD_OP_METHOD_ID	NUMBER	(10)	Yes
PARAMETER_ID	NUMBER	(10)
LEGACY_PARAM_NAME	VARCHAR2	(80)
SORT_ORDER	NUMBER	(5)	Yes
PARAM_SIGN_REVERSAL	VARCHAR2	(3)

Query Text

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


SELECT COORD_OP_METHOD_ID
,      PARAMETER_ID
,      LEGACY_PARAM_NAME
,      SORT_ORDER
,      PARAM_SIGN_REVERSAL
FROM MDSYS.SDO_COORD_OP_PARAM_USE;

Dependencies

[top of page]

MDSYS.SDO_COORD_OP_PARAM_USE does not reference any database object

MDSYS.SDO_COORD_OP_PARAM_USE is referenced by following:

MDSYS: SDO_CS - show dependent code
PUBLIC: SDO_COORD_OP_PARAM_USE