执行下面语句中的select 后面的查询语句时，没有任何问题，为什么填上前面的insert into 就报ora-01722 invalid number ,光标指向group by 中的a.jsjdm,这个a.jsjdm 有什么问题吗？
insert into temp_2008 (jsjdm,organ_name,fpzje_2009) select (a.jsjdm),(d.organ_name),sum(b.zcfpje-tpje)
from tfp_nsrjbxx a,js_skskj_fphz@XIAOXITIAN b,pub_stru c,pub_organ d
where a.nsrsh=b.nsrsbh
and b.kpqssj>=to_date('20090101','yyyy-mm-dd')
and b.kpjzsj<=to_date('20091231','yyyy-mm-dd')
and a.zgfj=c.stru_id
and c.organ_id=d.organ_id
and a.jsjdm in ('12776884',
'01111420',
'03184910',
'09427430',
'09262750',
'12753982',
'12755914',
'12770941',
'12827630',
'12755894',
'12760955',
'12778901',
'12893950',
'12721910',
'02286473',
'06548210',
'11146490',
'11232230',
'11354784',
'05A16610',
'12750093',
'11387690',
'11028130',
'05189906',
'05020964',
'05075329',
'05145917',
'05441890',
'05231350',
'05335220',
'05544850',
'05837990',
'05950840',
'05049260',
'05131805',
'05146810',
'05198625',
'05753470',
'09188590',
'18030030',
'05054361',
'05111375',
'05204141',
'09115330',
'18156460',
'20310830',
'02148230',
'05208589',
'12772393',
'14301000',
'14413710',
'14500297',
'14432464',
'14438437',
'14347240',
'09214040',
'18078070',
'15210710',
'07438980',
'07221980',
'07239510',
'07537718',
'07548469',
'07517214',
'07506732',
'07129290',
'07270320',
'07400310',
'07515138',
'06206410',
'06290631',
'06082471',
'06195831',
'06805750',
'06894150',
'05103336',
'06248012',
'06302180',
'06330142',
'06512232',
'06572242',
'06587161',
'06718990',
'06A17670',
'06570082',
'06222840',
'06553350',
'06243302',
'06849860',
'16248600',
'18118250',
'18147850',
'18168870',
'18179400',
'08116496',
'08000609',
'08094570',
'13028234',
'04145650',
'04227140',
'04251300',
'02777900',
'02230980')
group by a.jsjdm,d.organ_name |
免费注册
发表于 2011-04-19 16:51
