oracle分割字符串 

SELECT SUBSTR('1223_1',0,INSTR('1223_1','_', 1, 1)-1) "INSTRING",
       INSTR('1223_1','_', 1, 1) FROM DUAL
posted @ 2019-12-23 13:33  冬天不眠  阅读(768)  评论(0)  编辑  收藏  举报