Re: Update Problem
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 30 Aug 2001 00:44:28 +0200
Message-ID: <toqt2n13rpnc51_at_news.demon.nl>
Date: Thu, 30 Aug 2001 00:44:28 +0200
Message-ID: <toqt2n13rpnc51_at_news.demon.nl>
[Quoted] "Thomas Gorn" <thomas_betsabe_at_t-online.de> wrote in message
news:3b8d562e$1_at_news.piro.net...
> Hello,
>
> I have a table with userdata on Oracle DB.
> In one field I store the email. Now the mail adress
> firstname.surname_at_firma-bla.de have changed to firstname.surname_at_firma.de
.
> Can I realized this with a sql statement?
>
> Thanks
>
> Tom
>
>
Yes
You need to use the replace function.
Please look it up in your sql reference manual.
Hth,
Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 30 2001 - 00:44:28 CEST