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!

Clean Up Addresses Advice Needed

GmoneyNov 26 2012 — edited Nov 26 2012

I have what I think is a simple question. I have an Address table that has entries such as:

10221 E COUNTY RD 700 N
10221 E COUNTY ROAD 700 N

1401 S ASH ST
1401 S ASH STREET

I would like to clean it up, begining with the abbreviations.

' ST ','STREET',
' RD ','ROAD',
' LN ','LANE',
' DR ','DRIVE', etc.

Can anyone suggest or provide me some tips on how to "clean up" addresses?

Regards,

G

This post has been answered by Frank Kulash on Nov 26 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2012

Added on Nov 26 2012

15 comments

1,250 views