SQL Language (MOSC)

MOSC Banner

How extract number from column

edited Dec 23, 2013 7:07PM in SQL Language (MOSC) 6 commentsAnswered
I have a table, 2 columns contain security number like 111-22-3333

We want to replace this number with xxx-xx-xxxx

table A has 2 columns, column1 is primary key and column2 has value , CLMS NSSN 111-22-3333

select * from A;

column1   column2                                                

1               CLMS NSSN 111-22-3333

2              GAVE PH 111-22-33333

3               PROP MGR GV SSN 222-22-2222(?)

How can I replace CLMS NSSN 111-22-3333 into CLMS NSSN xxx-xx-xxxx and PROP MGR GV SSN 222-22-2222(?) into PROP MGR GV SSN xxx-xx-xxxx(?)?

Thanks,

Tracy

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center