关于Oracle字符串截取的问题

Question

现有一个字符串格式为"20090313001-1-12-5"
如何截取最后一个"-"之后的字符

Answer 1

SELECT substr('20090313001-1-12-5',instr('20090313001-1-12-5','-',-1)+1) substr FROM dual;

Answer 2

SELECT Substr('20090313001-1-12-5',INSTR('20090313001-1-12-5','-',-1) + 1) AS aa FROM dual

Answer 3

要保证字段中存在"-",加where条件:SELECT substr(字段,instr(字段,'-',-1)+1) substr 
FROM tb
WHERE instr(字段,'-')>0;

Answer 4

SELECT SUBSTR('20090313001-1-12-5',-1,INSTR('20090313001-1-12-5','-')) FROM DUAL;