原始数据
将Excle数据导入Oracle数据库上一篇博文已经介绍了。下面介绍如何将每一行数据中需要的数据截取下来。
SELECT * from excle2 where INSTR(NAME, ',category')>0;
select substr(name,instr(name,',category')) from EXCLE2;
select instr(name,',category',-1,1) from EXCLE2;
select instr(name,',category') from EXCLE2;
update EXCLE2 set NAME= REPLACE(name, substr(name,instr(name,',category')) , ' ');
select instr(type,'goodsWeight') from excle2;
update EXCLE2 set TYPE= REPLACE(type, substr(type,instr(type,'goodsWeight')) , ' ');