很有用的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(

1<c1>,<c2>[,<i>[,<j>]])  在  c1  中从位置  i  开始查找  c2  在  c1  中出第  j  次的位置，  i  可以为负  (  此时，从  c1  的尾部开始  )  。</j></i></c2></c1>