get string from right hand side

If you want to list last 3 chars, simplest way is

 select substr('123456',-3) from dual;