Re: Help -- NULL value assignment

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 22 Oct 1999 09:55:54 +0200
Message-ID: <940578976.10711.0.pluto.d4ee154e@news.demon.nl>

One solution would be
update p_item a
set a.unit = (select b.unit

                   from histpay b
                   where b.employee# = a.employee#)

where a.employee# in (select b.employee# from histpay b where b.unit is not null)

Hth,

--
Sybrand Bakker, Oracle DBA
Frank Ye <fye_at_laurel.ocs.mq.edu.au> wrote in message news:7up3g9$bmp$1_at_sunb.ocs.mq.edu.au...
> Hi there,
>
> I'd like to have the statement to produce the result
> like
>
> update p_item a
> set a.unit = NVL((select b.unit
> from histpay b
> where b.employee# = a.employee#
> ),a.unit)
>
> I know this is not working, but I want to keep the
> value of "a.unit" if the "select" gets no value. Anyone
> knows how to do it without writing PL/SQL procedure?
>
> Thanks in advance.
> Frank
>
>
Received on Fri Oct 22 1999 - 02:55:54 CDT