Re: nvl and subquery

From: Mark Plant <mplant_at_uk.oracle.com>
Date: Tue, 06 Jul 1999 11:12:09 GMT
Message-ID: <3781e355.3631397@newshost.uk.oracle.com>

Celia

I assume what you are trying to do is set the commission for employee 7902 to the same value as employee 8888, unless employee 8888 commission is null, in which case set 7902's commission to 99.

The statement to do this is -

update emp set comm =

       (select nvl(comm, 99) 
        from   emp 
        where  empno = 8888)

where empno = 7902;

Hope this helps.

If that isn't what you are trying to do, post a description of your problem so we can have another go.

Mark  

On Sun, 04 Jul 1999 02:02:31 GMT, celia9268_at_my-deja.com wrote:

>Hi, everybody.
>I would like to do an insert:
>
>SQL>insert into emp(comm)
> values ( nvl(select comm from emp where empno=8888), 99)
> where empno=7902;
>
>Unfortunately, this statement doesn't work. I know this can be done in
>pl/sql, but i really want to know whether this can be done in SQL?
>Please help.
>
>Regards
>celia
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jul 06 1999 - 06:12:09 CDT