ora-01756 : 引号内的字符串没有正确结束

Question

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;

Answer 1

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;

Answer 2

--rt.xm,'','',',rt.bzsj,rt.zzsj,rt.bzsj,这里只有1个单引号阿

Answer 3

rt.xm,'','',',rt.bzsj,rt.zzsj,rt.bzsj,  少了一个分号

Answer 4

rt.xm,'','',',rt.bzsj,rt.zzsj,rt.bzsj,
 

Answer 5

rt.xm,
         '',
         '',
         ',rt.bzsj,rt.zzsj,rt.bzsj,看出来了吧？少了一个引号你可以用plsql 编译一下格式  就能看出错了