I know it's very simple but i'm missing something here..kindly help.
I have a query like this :
select SUBSTR (CHAR ((DIGITS (ssn_no))), 1, 9) as ssn_no
which works fine.Now the requirement is to get only the last 4 digits of ssn.So, i tried the following and got an error.
select SUBSTR (CHAR ((DIGITS (ssn_no))), 5, 9) as ssn_no
What am i missing? Please advise.