mybatis中语句块报错， ORA-00918: 未明确定义列

解决MyBatis中语句块报错ORA-00918:未明确定义列

最新推荐文章于 2022-08-22 15:15:25 发布

转载最新推荐文章于 2022-08-22 15:15:25 发布 · 8.3k 阅读

SSH 专栏收录该内容

85 篇文章

订阅专栏

mybatis中语句块报错， ORA-00918: 未明确定义列，求救啊 [问题点数：50分，结帖人defonds]

关注

weiwei4755822

本版等级：

结帖率：100%

楼主发表于： 2013-08-15 19:14:25

本帖最后由 weiwei4755822 于 2013-08-15 19:15:51 编辑

<select id="findPage"  parameterType="map" resultType="map">
  SELECT * FROM (SELECT ROWNUM RN , BIC_PAGING.* FROM (
        select A.vlist_detail_code,
A.vlist_detail_name ,
B.vlist_detail_name ,
decode(A.record_status,0,'启用',1,'停用'),
C.vlist_detail_name ,
F.emp_name ,
A.create_date ,
G.emp_name ,
G.modify_date ,
A.remark
from t_bic_vlist_detail A ,
t_bic_vlist_detail  B ,
t_bic_vlist_detail   C ,
(select D.user_id ,E.emp_name from t_bic_emp E left join t_bic_user D on E.emp_id=D.emp_id)  F ,
(select P.user_id ,T.emp_name,T.modify_date from t_bic_emp T left join t_bic_user P on T.emp_id=P.emp_id) G
<where>
  A.brand=B.vlist_detail_code
          and A.vlist_parent_detail_code=C.vlist_detail_code
          and A.create_user=F.user_id
          and A.modify_user=G.user_id

myeclipse中报错，Caused by: java.sql.SQLSyntaxErrorException: ORA-00918: 未明确定义列

frameborder="0" src="http://tpc.googlesyndication.com/safeframe/1-0-2/html/container.html#xpc=sf-gdn-exp-1&p=http%3A//bbs.youkuaiyun.com" id="google_ads_iframe_/8456/IDG.CN_B2B_youkuaiyun.com_0" name="1-0-2;69156;

scrolling="no" frameborder=0 height=0 width=0 src="http://cm.g.doubleclick.net/push?client=ca-pub-7443704194229694" style="position:absolute">

该广告已关闭。撤消

此广告有什么问题？

不相关

内容不当

重复显示

{"uid":1,"hostPeerName":"http://bbs.youkuaiyun.com","initialGeometry":"{\"windowCoords_t\":59,\"windowCoords_r\":1178,\"windowCoords_b\":558,\"windowCoords_l\":134,\"frameCoords_t\":1171,\"frameCoords_r\":1093.5,\"frameCoords_b\":1261,\"frameCoords_l\":365.5,\"styleZIndex\":\"auto\",\"allowedExpansion_t\":0,\"allowedExpansion_r\":0,\"allowedExpansion_b\":0,\"allowedExpansion_l\":0,\"xInView\":0,\"yInView\":0}","permissions":"{\"expandByOverlay\":false,\"expandByPush\":false,\"readCookie\":false,\"writeCookie\":false}","metadata":"{\"shared\":{\"sf_ver\":\"1-0-2\",\"ck_on\":1,\"flash_ver\":\"20.0.0\"}}","reportCreativeGeometry":false}" scrolling="no" marginwidth="0" marginheight="0" width="728" height="90" data-is-safeframe="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom;">

id="iframeu1636200_0" src="http://pos.baidu.com/acom?rdid=1636200&dc=2&di=u1636200&dri=0&dis=0&dai=2&ps=1187x709&dcb=BAIDU_UNION_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1456102771999&ti=mybatis%E4%B8%AD%E8%AF%AD%E5%8F%A5%E5%9D%97%E6%8A%A5%E9%94%99%EF%BC%8C%20ORA-00918%3A%20%E6%9C%AA%E6%98%8E%E7%A1%AE%E5%AE%9A%E4%B9%89%E5%88%97%EF%BC%8C%E6%B1%82%E6%95%91%E5%95%8A-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT&ari=1&dbv=2&drs=1&pcs=1279x504&pss=1279x1217&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1456102772&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F390549792&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DNvKBmiSZYqT617q3BW6D87YgBfVPfNXlbj-OhHzVaUQIbKDh0agX7vAo5Bq3WNqC%26wd%3D%26eqid%3Df2698f75001c6e7e0000000556ca5d18&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1456102773&qn=619fba1b5cabfb20&tt=1456102771967.622.988.988" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
id="iframeu1636201_0" src="http://pos.baidu.com/acom?rdid=1636201&dc=2&di=u1636201&dri=0&dis=0&dai=3&ps=1204x731&dcb=BAIDU_UNION_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1456102771999&ti=mybatis%E4%B8%AD%E8%AF%AD%E5%8F%A5%E5%9D%97%E6%8A%A5%E9%94%99%EF%BC%8C%20ORA-00918%3A%20%E6%9C%AA%E6%98%8E%E7%A1%AE%E5%AE%9A%E4%B9%89%E5%88%97%EF%BC%8C%E6%B1%82%E6%95%91%E5%95%8A-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT&ari=1&dbv=2&drs=1&pcs=1279x504&pss=1279x1241&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1456102772&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F390549792&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DNvKBmiSZYqT617q3BW6D87YgBfVPfNXlbj-OhHzVaUQIbKDh0agX7vAo5Bq3WNqC%26wd%3D%26eqid%3Df2698f75001c6e7e0000000556ca5d18&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1456102773&qn=0c34cb9d253a7772&tt=1456102771967.739.794.794" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
id="iframeu1636204_0" src="http://pos.baidu.com/acom?rdid=1636204&dc=2&di=u1636204&dri=0&dis=0&dai=4&ps=1209x853&dcb=BAIDU_UNION_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1456102771999&ti=mybatis%E4%B8%AD%E8%AF%AD%E5%8F%A5%E5%9D%97%E6%8A%A5%E9%94%99%EF%BC%8C%20ORA-00918%3A%20%E6%9C%AA%E6%98%8E%E7%A1%AE%E5%AE%9A%E4%B9%89%E5%88%97%EF%BC%8C%E6%B1%82%E6%95%91%E5%95%8A-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT&ari=1&dbv=2&drs=1&pcs=1279x504&pss=1279x1246&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1456102772&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F390549792&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DNvKBmiSZYqT617q3BW6D87YgBfVPfNXlbj-OhHzVaUQIbKDh0agX7vAo5Bq3WNqC%26wd%3D%26eqid%3Df2698f75001c6e7e0000000556ca5d18&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1456102773&qn=4f08ac5b2cef46a1&tt=1456102771967.838.985.985" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">

对我有用[0] 丢个板砖[0] 引用 | 举报 | 管理

回复次数：3

关注 terablade terablade 本版等级：	#1 得分：30 回复于： 2013-08-15 19:25:48 ORA-00918: 未明确定义列这个错误的意义是说在连接查询时某一个列同时出现在多个表中，sql不知道应该使用哪一个列
	对我有用[0] 丢个板砖[0] 引用 \| 举报 \| 管理

关注 zhkchi zhkchi 本版等级：	#2 得分：10 回复于： 2013-08-15 22:58:51 连表操作的时候, 明确表名字!
	对我有用[0] 丢个板砖[0] 引用 \| 举报 \| 管理