But then it's not a null, it's a space character.
C. Ferguson <c_ferguson_at_rationalconcepts.com> wrote in message
news:385699B4.B9FE4075_at_rationalconcepts.com...
> 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 Wed Dec 15 1999 - 08:59:08 CST