Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!news-xfer1.atl.newshosting.com!news-west.eli.net!not-for-mail
Message-ID: <3DCFD942.20ECED04@exesolutions.com>
From: Daniel Morgan <dmorgan@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: Newbie
References: <aqe9hc$q7u$1@nsnmpen2-gest.nuria.telefonica-data.net> <3dce0db0$0$8511$cc9e4d1f@news.dial.pipex.com> <dnessuke9luo26smvaue7cjqd8hsg9mdis@4ax.com> <3dce5065$0$13369$cc9e4d1f@news.dial.pipex.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 36
Date: Mon, 11 Nov 2002 16:22:47 GMT
NNTP-Posting-Host: 156.74.250.7
X-Complaints-To: yvonne.tracy@ci.seattle.wa.us
X-Trace: news-west.eli.net 1037031767 156.74.250.7 (Mon, 11 Nov 2002 09:22:47 MST)
NNTP-Posting-Date: Mon, 11 Nov 2002 09:22:47 MST
Organization: City of Seattle NewsReader Service
Xref: newsfeed1.easynews.com comp.databases.oracle.tools:54728
X-Received-Date: Mon, 11 Nov 2002 09:22:39 MST (news.easynews.com)

Niall Litchfield wrote:

> "Sybrand Bakker" <gooiditweg@sybrandb.demon.nl> wrote in message
> news:dnessuke9luo26smvaue7cjqd8hsg9mdis@4ax.com...
> > On Sun, 10 Nov 2002 07:41:33 -0000, "Niall Litchfield"
> > <niall.litchfield@dial.pipex.com> wrote:
> >
> > >I wonder , in MSSQL you can do a REPLACE, could it be possible that there
> is
> > >a REPLACE statatement supported by Oracle? If there is maybe its in one
> of
> > >the manuals.
> >
> >
> > In the SQL Reference Manual, to be exact.
> > Together with TRANSLATE.
> > Of course it could be easily simulated with substr and instr
>
> spoilsport <g>.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************

I don't think he saw the emoticons for tongue-in-cheek and rhetorical remark.
;-)

Daniel Morgan