| 本月文章推荐 |
很有用的oracle 函数发表日期：2008-2-9
|
|
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的尾部开始)。 |
| 上一篇：Oracle在Linux下的安装
人气:1384 下一篇：Oracle中Number(p,s)的意义 人气:1081 |
| 浏览全部Oracle教程的内容
Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐 |
