select
t.text,
substr(t.text,1,instr(t.text,'=')-1) a,
substr(t.text,instr(t.text,'=')+1) b
from
dic.jk_dic_audit t
t.text,
substr(t.text,1,instr(t.text,'=')-1) a,
substr(t.text,instr(t.text,'=')+1) b
from
dic.jk_dic_audit t
-------------------------------------------------------------------------------------
update dic.jk_dic_audit t set t.text1=substr(t.text,1,instr(t.text,'=')-1),t.text2=substr(t.text,instr(t.text,'=')+1)
查询出单列结果进行截取保存或者修改,如下:
![Oracle 数据列值拆分 - 浮水弹心 - zhao.xuepu Oracle 数据列值拆分 - 浮水弹心 - zhao.xuepu](http://img6.ph.126.net/oNvfsZMBGqVsbepjR1ri1Q==/110056715911790226.jpg)