Re: Simple SQL question

From: <yong321_at_yahoo.com>
Date: 1 Feb 2006 07:03:00 -0800
Message-ID: <1138806180.864993.112490@f14g2000cwb.googlegroups.com>

If people keep beating the dead horse with a whip others have never seen, it's worth it. This is more common in the Perl community where "there's more than one way to do it" is a motto. Your queries definitely work. Slightly expanding the OP's request beyond replacing consecutive white spaces may help others that need string manipulation in the future.

For those stuck with pre-10g, there's an owa_pattern package that has existed since Oracle 7.1.3 or maybe earlier. Read $ORACLE_HOME/rdbms/admin/pubpat.sql for examples.

Yong Huang Received on Wed Feb 01 2006 - 09:03:00 CST