Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle varchar problem - Difficult
You might want to take a look at the NVL function. If I remember correctly
you can't compare to a NULL
Christopher Burke <craznar_at_hotmail.com> wrote in message
news:90414412ECraznar_at_61.9.128.12...
> afilonov_at_pro-ns.net (Alex Filonov) wrote in <95p69a$7ut$1_at_nnrp1.deja.com>:
>
> >
> >update blob
> >set dirty = 'Y', value = new_value
> >where not(value = new_value)
> >
> >In case when either value or new_value is null, result of
> >value = new_value is false, so this case is covered too.
> >
>
> However if the old and new values are both '' - then the field will be
> updated even though the data hasn't changed (i.e. dirty will be set to
> 'Y').
> --
> ---
> /* Christopher Burke - Spam Mail to craznar_at_hotmail.com
> |* www.craznar.com - International Internet Writing Experiment
> \* Real mail to cburke(at)craznar(dot)com
Received on Fri Feb 09 2001 - 13:26:30 CST