SELECT
ELLIPSOID_NAME "NAME",
SEMI_MAJOR_AXIS "SEMI_MAJOR_AXIS",
INV_FLATTENING "INVERSE_FLATTENING"
FROM
MDSYS.SDO_ELLIPSOIDS
WHERE
NOT (INV_FLATTENING IS NULL)
UNION
SELECT
ELLIPSOID_NAME "NAME",
SEMI_MAJOR_AXIS "SEMI_MAJOR_AXIS",
(SEMI_MAJOR_AXIS/(SEMI_MAJOR_AXIS - SEMI_MINOR_AXIS)) "INVERSE_FLATTENING"
FROM
MDSYS.SDO_ELLIPSOIDS
WHERE
(INV_FLATTENING IS NULL)
AND
(SEMI_MINOR_AXIS < SEMI_MAJOR_AXIS)
UNION
SELECT
ELLIPSOID_NAME "NAME",
SEMI_MAJOR_AXIS "SEMI_MAJOR_AXIS",
1000000000000 "INVERSE_FLATTENING"
FROM
MDSYS.SDO_ELLIPSOIDS
WHERE
(INV_FLATTENING IS NULL)
AND
NOT (SEMI_MINOR_AXIS < SEMI_MAJOR_AXIS)
SELECT
ELLIPSOID_NAME "NAME"
,
SEMI_MAJOR_AXIS "SEMI_MAJOR_AXIS"
,
INV_FLATTENING "INVERSE_FLATTENING"
FROM
MDSYS.SDO_ELLIPSOIDS
WHERE
NOT (INV_FLATTENING IS NULL)
UNION
SELECT
ELLIPSOID_NAME "NAME"
,
SEMI_MAJOR_AXIS "SEMI_MAJOR_AXIS"
,
(SEMI_MAJOR_AXIS/(SEMI_MAJOR_AXIS - SEMI_MINOR_AXIS)) "INVERSE_FLATTENING"
FROM
MDSYS.SDO_ELLIPSOIDS
WHERE
(INV_FLATTENING IS NULL)
AND
(SEMI_MINOR_AXIS < SEMI_MAJOR_AXIS)
UNION
SELECT
ELLIPSOID_NAME "NAME"
,
SEMI_MAJOR_AXIS "SEMI_MAJOR_AXIS"
,
1000000000000 "INVERSE_FLATTENING"
FROM
MDSYS.SDO_ELLIPSOIDS
WHERE
(INV_FLATTENING IS NULL)
AND
NOT (SEMI_MINOR_AXIS < SEMI_MAJOR_AXIS)
|
|
|