How to get rightmost 10 places of a string in oracle

June 1, 2023 by Tarik

You can use SUBSTR function as:

select substr('TN0001234567890345',-10) from dual;

Output:

4567890345