Question

执行数据库语句时，报oracle 中ORA-00913：值过多 的错误

insert into xg_zhcp_zcfsb
(xh, xn, xq, xmdm, fs, lrr,lrsj) select a.xh,a.xh2, a.xh3, (select xmdm from xg_zhcp_zcxmb t1
where t1.xn || t1.xq = a.xh2 || a.xh3 and xmmc = '能力素质测评') as xmdm,
a.xh4, 'zf01', '2014-07-08 11:50:16' from temp004 a
where (xh, xh2, xh3) not in (select *
from (select a.xh,
a.xh2,
a.xh3,
(select xmdm
from xg_zhcp_zcxmb t1
where t1.xn || t1.xq = a.xh2 || a.xh3
and xmmc = '能力素质测评') as xmdm,
a.xh4,
'zf01',
'2014-07-08 11:50:16'
from temp004 a)
where (xh, xh2, xh3) in
(select xh, xh2, xh3
from (select a.xh,
a.xh2,
a.xh3,
(select xmdm
from xg_zhcp_zcxmb t1
where t1.xn || t1.xq = a.xh2 || a.xh3
and xmmc = '能力素质测评') as xmdm,
a.xh4,
'zf01',
'2014-07-08 11:50:16'
from temp004 a)
group by (xh, xh2, xh3)
having count(*) > 1))

执行时一直报 where in 后面挂号select处值错误，但是单独执行挂号里面却没有问题，求高手指点

Answer 1

insert into xg_zhcp_zcfsb
(xh, xn, xq, xmdm, fs, lrr,lrsj) select
这是你写的, 但是你后面select出来的字段大于7个, 自然就报错了