sql语句如下:select leading(t),/*no_index(t,INX_ANF_SSCB_AFFICTAG_BITMAP),t.poiid,distinct(t.POIID),*/
t.AFFILIATE,
t.AFFITAG,
t.NAME,
t.KEY_TYPE,
t.XY_COORD.SDO_POINT.x * 3600000 || ';' ||
t.XY_COORD.SDO_POINT.Y * 3600000,
t.XY_COORD_ENT,
t.PDASURVEYTAG,
t.UPDATE_STATUS,
t.PRECISION,
t.MODEL_FLAG,
t.MODEL_ANG,
t1.CHNTYPE,
t1.CHNTEXT,
t1.CHNSCALE,
T1.ISOK,
T1.UPDATE_STATUS,
T2.LMSCALE,
T2.ISOK,
T2.UPDATE_STATUS
from anf_shicaicaibian t, anf_chntext t1, anf_land t2
WHERE SDO_RELATE(t.xy_coord,
mdsys.sdo_geometry(2003,
8307,
NULL,
mdsys.sdo_elem_info_array(1, 1003, 1),
mdsys.sdo_ordinate_array(121.431694065332,
31.255021523641,
121.441459051858,
31.255021523641,
121.441459051858,
31.263024000428,
121.431694065332,
31.263024000428,
121.431694065332,
31.255021523641)),
'mask=INSIDE querytype=WINDOW') = 'TRUE'
and t.affitag != 3
and t1.poiid(+) = t.poiid
and t2.poiid(+) = t.poiid
第一行就出错:leading 无法识别,弹出错误:ORA-00904 LEADING invalid identifier
还请高手指教啊
t.AFFILIATE,
t.AFFITAG,
t.NAME,
t.KEY_TYPE,
t.XY_COORD.SDO_POINT.x * 3600000 || ';' ||
t.XY_COORD.SDO_POINT.Y * 3600000,
t.XY_COORD_ENT,
t.PDASURVEYTAG,
t.UPDATE_STATUS,
t.PRECISION,
t.MODEL_FLAG,
t.MODEL_ANG,
t1.CHNTYPE,
t1.CHNTEXT,
t1.CHNSCALE,
T1.ISOK,
T1.UPDATE_STATUS,
T2.LMSCALE,
T2.ISOK,
T2.UPDATE_STATUS
from anf_shicaicaibian t, anf_chntext t1, anf_land t2
WHERE SDO_RELATE(t.xy_coord,
mdsys.sdo_geometry(2003,
8307,
NULL,
mdsys.sdo_elem_info_array(1, 1003, 1),
mdsys.sdo_ordinate_array(121.431694065332,
31.255021523641,
121.441459051858,
31.255021523641,
121.441459051858,
31.263024000428,
121.431694065332,
31.263024000428,
121.431694065332,
31.255021523641)),
'mask=INSIDE querytype=WINDOW') = 'TRUE'
and t.affitag != 3
and t1.poiid(+) = t.poiid
and t2.poiid(+) = t.poiid
第一行就出错:leading 无法识别,弹出错误:ORA-00904 LEADING invalid identifier
还请高手指教啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货