日期:2014-05-17  浏览次数:22671 次

ora-01756 : 引号内的字符串没有正确结束
insert into reader(id,status,school_id,
school_code,reader_type_code,reader_barcode,
account,password,name,identify_code,birthday,
sex,start_date,end_date,create_date,address,postcode,
email,state,reader_type_id,school_dept_id) 
select s_reader.nextval,1,1100,'330327002103'
,rt.dzjb,rt.txm,rt.txm,'8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92',
rt.xm,'','',',rt.bzsj,rt.zzsj,rt.bzsj,
'','','',1,2,sd.id
from reader_temp rt left join school_dept sd 
on rt.dzdw=sd.name 
where sd.school_id=1100;

------解决方案--------------------
新增數據時:操作字段值的數量,要和你想要插入的列數保持數量上一致,不然也會出錯的