截取字符串

一个字符串：***.****.*****,要截取后面的5个*
oracle命令：select substr('4.1001.010',
instr('4.1001.010',
'.',
-1,
1) + 1) from dual;