select substr('adf!fff!rrrr!33333f ',instr('adf!fff!rrrr!33333f ','!',-1,1)+1) a from dual union all select substr('啊啊!22!ff!22222 ',instr('啊啊!22!ff!22222 ','!',-1,1)+1) a from dual; -- 33333f 22222
取一个来说 select substr('啊啊!22!ff!22222',instr('啊啊!22!ff!22222','!',-1,1)+1) from dual
select substr('啊啊!22!ff!22222 ',instr('啊啊!22!ff!22222 ','!',-1,1)+1) a from dual;
--
33333f
22222
select substr('啊啊!22!ff!22222',instr('啊啊!22!ff!22222','!',-1,1)+1) from dual