Re: help!! problem in update, replace null with empty string ''

The blank string '' is null to oracle.
Put a space between the single quotes. ' '

cindy

Nicole Weidemann wrote:

> Hi Frank,
> I had a similar problem. I forgot the COMMIT statement. Maybe your problem
> is as easy as that.
> Ciao, Nicole
>
> Frank Yu Fang schrieb:
>
> > Friends:
> > I'm using Oracle 8.
> > I want to replace all null values in a column with empty string (i.e.
> > ''). Here is what happened:
> >
> > Originally:
> > SQL> select id from nrigateway where COMMUNITY is null;
> >
> > ID
> > ----------
> > 90
> > 93
> >
> > I update:
> > SQL> update nrigateway set COMMUNITY='' where COMMUNITY is null;
> >
> > 2 rows updated.
> >
> > Now let's see:
> > SQL> select id from nrigateway where COMMUNITY is null;
> >
> > ID
> > ----------
> > 90
> > 93
> > The values are still null!!!!!!
> >
> > '' is not even put in:
> > SQL> select id from nrigateway where COMMUNITY='';
> >
> > no rows selected
> >
> > SQL>
> >
> > Please help. I couldn't find anything in Oracle document.
Received on Tue Dec 14 1999 - 13:24:55 CST