Re: Managing large physical mailings ...

  • From: stv <stvsmth@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 3 Oct 2006 17:04:54 -0600

Ahhh, excellent suggestion; I believe the master database has a soundex column.

On 10/3/06, Dennis Williams <oracledba.williams@xxxxxxxxx> wrote:
You're getting some great advice. On the do-it-yourself front, take a look
at the SOUNDEX routine built into SQL. Helps a lot on dealing with minor
spelling variations.

Someone else mentioned regex in 10 (we're on 9, but we can move the data-set to an XE instance). Not searching Oracle directlly, I did find this:

The sample data consists of a list of address strings. The table that
holds this data is named XXADDR and contains only one column,
ADDRESS_LINE1, of type VARCHAR2(300). Our test scenario involves a
requirement to standardize street abbreviations to comply with the
U.S. Postal Service standard (described in Appendix E of Postal
Addressing Standards). A sample of the standard is shown below:

Other related posts: