Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Easy JOIN question for the pros
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