Hello All,

Here is my hickup!

I am trying to create a table from the following unions, but I get the ERROR

ORA-00998: must name this expression with a column alias


CREATE TABLE ROUTES AS
SELECT s.CODE_SIG_P_ID, s.DPM_DPN_MID, gf_geolatvalue(geo_lat), gf_geolongvalue(geo_long) from
SIGNIFICANT_POINT s, DESIGNATED_POINT d
where s.DPM_DPN_MID= d.DPM_DPN_MID
UNION
SELECT s.CODE_SIG_P_ID, s.NDBM_CODE_NDB_ID, gf_geolatvalue(geo_lat), gf_geolongvalue(geo_long) from
SIGNIFICANT_POINT s, NDB d
where s. NDBM_CODE_NDB_ID = d. NDBM_CODE_NDB_ID;

Could anyone lead me through.

Sowa


Oracle LazyDBA home page