Re: Simple SQL question

From: Mahesh Rajendran <Magvivek_at_gmail.com>
Date: 31 Jan 2006 10:01:33 -0800
Message-ID: <1138730493.268318.247790@z14g2000cwz.googlegroups.com>

--

• in 10g
• Thanks to Aketi. http://oraclesqlpuzzle.hp.infoseek.co.jp/
  --
  SCOTT > ed Wrote file afiedt.buf

  1 select regexp_replace('the cat sat on the mat', ' {2,}', ' ')
  2* from dual
SCOTT > / REGEXP_REPLACE('THECAT

---

the cat sat on the mat

SCOTT > ed
Wrote file afiedt.buf

  1* select regexp_replace('the cat sat on the mat',' +',' ') from dual
SCOTT > / REGEXP_REPLACE('THECAT

---

the cat sat on the mat

--

• In 9i
  --
  SCOTT > ed Wrote file afiedt.buf

  1* select replace(replace('the cat sat on the mat',' ',' '),' ',' ') from dual
SCOTT > / REPLACE(REPLACE('THECA

---

the cat sat on the mat Received on Tue Jan 31 2006 - 12:01:33 CST