How to get rightmost 10 places of a string in oracle

user_453548 0
Viewed 112918

I am trying to fetch an id from an oracle table. It's something like TN0001234567890345. What I want is to sort the values according to the right most 10 positions (e.g. 4567890345). I am using Oracle 11g. Is there any function to cut the rightmost 10 places in Oracle SQL ?

Thanks in advance

tismon

oracle11g sorting oracle sql
5 Answers
SQL> SELECT SUBSTR('00000000123456789', -10) FROM DUAL;

Result: 0123456789

user_119991030
Related