exception ORA-00918: 未明确定义列
CreateTime--2018年5月9日16:08:48
Author:Marydon
1.错误代码展示
SELECT G.*
FROM (SELECT F.*
FROM (SELECT E.*, ROWNUM ROWNO
FROM (SELECT T.ID,
T.VIRTUAL_ID,
T.INDEX_ID,
T.ID_CARD,
T.NAME,
T.CARDNUM,
T.CARDTYPE,
T.TELPHONE,
T.SEX,
TO_CHAR(T.BIRTHDAY, 'YYYY-MM-DD') BIRTHDAY,
T.ADDRESS,
T.ACCESS_TYPE,
T.ACCESS_ID,
T.ENTITY_CARDTYPE,
T.ENTITY_CARDNUM,
T.RETURN_QR_CODE,
T.OPENID,
T.RANDOM,
TO_CHAR(T.TIME, 'yyyy-mm-dd hh24:mi:ss') TIME,
T.FNAME,
T.STATUS,
T.QR_CODE_TYPE
FROM VIRTUAL_CARD T, PRIMARY_INDEX T2
WHERE T.INDEX_ID = T2.INDEX_ID
and NAME = ?
and INDEX_ID like ? || '%') E
ORDER BY E.TIME DESC NULLS LAST) F
WHERE F.ROWNO <= ?) G
WHERE G.ROWNO >= ?
--[张旭, 410, 15, 1]
2.错误解析
T表和T2表都有字段INDEX_ID，而where条件的第二个INDEX_ID没有指定该字段从哪个表中获取，
所以报错。