Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

substr concatenation

651180May 27 2009 — edited May 27 2009

I have a social security like this
602-32-XXXX

xxxx(Security reasons)
I need to get rid off the -

so I run this query

select substr(szsmapp_ssn,1,3)||substr(szsmapp_ssn,5,6)||substr(szsmapp_ssn,8,11)
from szsmapp

and I am getting this result
60232-054XXXX

I need to be able to get only 9 digits...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2009

Added on May 27 2009

5 comments

1,940 views