当前位置: 代码迷 >> Oracle管理 >> 应用plsql无法识别oracle的hint关键字
  详细解决方案

应用plsql无法识别oracle的hint关键字

热度:26   发布时间:2016-04-24 04:56:17.0
使用plsql无法识别oracle的hint关键字
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_landmark 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,
  相关解决方案