很有用的oracle 函数

insert into 表名 select a.imarkno,substr(b.字段b,INSTR(b.字段b,',',1,1)+1,INSTR(b.字段b,',',1,2)-INSTR(b.字段b,',',1,1)-1),substr(b.字段b,INSTR(b.字段b,',',1,2)+1,INSTR(b.字段b,',',1,3)-INSTR(b.字段b,',',1,2)-1), substr(b.字段b,INSTR(b.字段b,',',1,3)+1,INSTR(b.字段b,',',1,4)-INSTR(b.字段b,',',1,3)-1), b.wangzhanlx,substr(b.domainname,INSTR(b.domainname,',',1,1)+1,INSTR(b.domainname,',',1,2)-INSTR(b.domainname,',',1,1)-1),substr(b.domainname,INSTR(b.domainname,',',1,2)+1,INSTR(b.domainname,',',1,3)-INSTR(b.domainname,',',1,2)-1), substr(b.domainname,INSTR(b.domainname,',',1,3)+1,INSTR(b.domainname,',',1,4)-INSTR(b.domainname,',',1,3)-1), c.glsj,c.glbp,'ywtxdz' from wzba_identifier a,wzba_mingchengfb b,wzba_beianfb c where a.iba_id=b.mc_id and a.iba_id=c.ba_id; INSTR(<c1>,<c2>[,<i>[,<j>]]) 在c1中从位置i开始查找c2在c1中出第j次的位置，i可以为负(此时，从c1的尾部开始)。