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_PRIME_MERIDIANS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: PRIME_MERIDIAN_PRIM

PRIME_MERIDIAN_ID

Unique Key: SYS_C00186522

PRIME_MERIDIAN_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PRIME_MERIDIAN_PRIM	NORMAL	UNIQUE	SYSTEM	PRIME_MERIDIAN_ID
SYS_C00186522	NORMAL	UNIQUE	SYSTEM	PRIME_MERIDIAN_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
SDO_PRIME_MERIDIANS		SDO_UNITS_OF_MEASURE	SDO_PRIME_MERIDIANS UOM_ID
SDO_DATUMS		SDO_PRIME_MERIDIANS	SDO_DATUMS PRIME_MERIDIAN_ID

Columns

Name	Datatype	Length	Mandatory
PRIME_MERIDIAN_ID	NUMBER	(10)	Yes
PRIME_MERIDIAN_NAME	VARCHAR2	(80)	Yes
GREENWICH_LONGITUDE	FLOAT	(22)
UOM_ID	NUMBER	(10)
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(254)

Query Text

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


SELECT PRIME_MERIDIAN_ID
,      PRIME_MERIDIAN_NAME
,      GREENWICH_LONGITUDE
,      UOM_ID
,      INFORMATION_SOURCE
,      DATA_SOURCE
FROM MDSYS.SDO_PRIME_MERIDIANS;

Dependencies

[top of page]

MDSYS.SDO_PRIME_MERIDIANS does not reference any database object

MDSYS.SDO_PRIME_MERIDIANS is referenced by following:

MDSYS: SDO_CS - show dependent code
PUBLIC: SDO_PRIME_MERIDIANS