-- 获取字符#前的字符串
select substr('12#1',1,instr('12#1','#')-1) from dual;
结果:
-- 获取字符#后面的字符串
select substr('12#1',instr('12#1','#',-1)+1) 值 from dual;
结果:
-- 获取字符#前的字符串
select substr('12#1',1,instr('12#1','#')-1) from dual;
结果:
-- 获取字符#后面的字符串
select substr('12#1',instr('12#1','#',-1)+1) 值 from dual;
结果: