The following sql (not written by me) does what I want but I'd really
like to understand the logic. Could somebody please explain? I'm
confused by all of the parameters.

<<<<<<<<<

SELECT
DECODE(NVL(C.USER_2,'NULL'),'YES',DECODE(NVL(P.USER_2,'NULL'),'YES','YES
','NO'),'NO') INTO NEW_USER_2

<<<<<<<<<

Thanks



Mike Brunson

Information Systems Manager

Delavan Spray Technologies

Goodrich Corporation

www.goodrich.com

www.delavan.com

Phone 803-245-4347 Ext 6563

e-mail mike.[Email address protected]



This email message and any attachments are for the sole use of the
intended recipients. This message may contain proprietary and/or
confidential information which may be privileged or otherwise protected
from disclosure. Any unauthorized review, use, disclosure, reproduction,
or distribution of the message and its contents is prohibited. If you
are not the intended recipients, please contact the sender by reply
email and destroy the original message, attachments, and any copies of
the message.




Oracle LazyDBA home page