Oracle數字求右5位,该如何解决

Oracle數字求右5位
"5000123456"
Oracle如何求這個數字的右5位--"23456"

[解决办法]

SQL code

SQL> SELECT SUBSTR('5000123456',LENGTH('5000123456')-4) "STR"  2    FROM DUAL;STR-----23456
[解决办法]
SQL code
OPER@tl>select substr('5000123456',-5) from dual;SUBSTR('50----------23456OPER@tl>