Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Easy JOIN question for the pros

Re: Easy JOIN question for the pros

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Jun 2005 09:46:23 -0700
Message-ID: <1118076383.860882.258670@g43g2000cwa.googlegroups.com>


James lookup the CASE statements in the SQL manual. You should be able to use it to alternate between returning the value and null in the third column.

You should also become familar with NULLIF, NVL, and COALESCE. You will find many uses for these functions for controling select list output.

HTH -- Mark D Powell -- Received on Mon Jun 06 2005 - 11:46:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US