你不是吧.常量你也用+号跟那么多引号?
insert into em_ring(ringcode,sringcode,ringname,singer,price,vdate,singerinitial,namecnum,ringtype)
values('002700000001','27000001','I DO(高潮版)','阿杜','3','2007.04.10','A','2','经典回放');
insert into em_ring(ringcode,sringcode,ringname,singer,price,vdate,singerinitial,namecnum,ringtype)
values('002700000001','27000001','I DO(高潮版)','阿杜','3','2007.04.10','A','2','经典回放');
values('"+002700000001+"','"+27000001+"','"+I DO(高潮版)+"','"+阿杜+"','3','"to_date('"+2007-04-10+"','yyyy-mm-dd')"','"+A+"','2','"+经典回放+"');报missing comma的错
ringcode
,sringcode
,ringname
,singer
,price
,vdate
,singerinitial
,namecnum
,ringtype
)
values
(
'"+002700000001+"'
,'"+27000001+"'
,'"+I DO(高潮版)+"'
,'"+阿杜+"'
,3
,to_date('2007-04-10','yyyy-mm-dd')
,'"+A+"'
,2
,'"+经典回放+"'
);
sqlstr = "insert into em_ring(ringcode,sringcode,ringname,singer,price,vdate,singerinitial,namecnum,ringtype) values('" + "002700000001 " + "','" + "27000001" + "','" + "IDO(高潮版)" + "','" + "阿杜" + "','3','"to_date('" + "2007-04-10" + "','yyyy-mm-dd')','" + "A" + "','2','" + "经典回放" + "')";另外,整数也可以用单引号(')引起来,oracle在执行时会进行内部的转换,将单引号(')引起来的值转换成整数值。