Re: sql help needed

Hi, Gianmarco

Sounds simple. Why don't you use the REPLACE function. Like this:

SQL> select replace('gianmarco,paris',',','_') from dual;

REPLACE('GIANMARCO,PARIS',',','_')

gianmarco_paris

Hope this is enough.

Michael Ringbo, mri_at_dde.dk

 gianmarco paris wrote:

> Hello everybody.
> I have the following problem, hope somebody can help me.
> I have table in an Oracle database (Oracle7 Server Release 7.2.2.3.0)
> and I
> am accessing. modifying updating my table by using sqlplus (PL/SQL
> Release
> 2.2.2.3.0) on Solaris 2.5.
> Ok, now the problem. I have to replace any character occurence on
> character
> fields. I cannot find an SQL commands to do that. UPDATE, as far as I
> have
> understood, does replace the whole field , but is there any way of
> replacing a character and not the field?
> Example: In the field I have the following string:
> gianmarco,paris
> I'd like it to become:
> gianmarco_paris
>
Received on Thu Feb 05 1998 - 00:00:00 CST