Re: Newbie
From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 10 Nov 2002 12:26:11 -0000
Message-ID: <3dce5065$0$13369$cc9e4d1f_at_news.dial.pipex.com>
Date: Sun, 10 Nov 2002 12:26:11 -0000
Message-ID: <3dce5065$0$13369$cc9e4d1f_at_news.dial.pipex.com>
[Quoted] "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:dnessuke9luo26smvaue7cjqd8hsg9mdis_at_4ax.com...
> On Sun, 10 Nov 2002 07:41:33 -0000, "Niall Litchfield"
> <niall.litchfield_at_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 ******************************************Received on Sun Nov 10 2002 - 13:26:11 CET