[thelist] SQL Question - 'Contingent Columns'
Joshua Olson
joshua at waetech.com
Tue Apr 16 11:28:01 CDT 2002
----- Original Message -----
From: "Luther, Ron" <Ron.Luther at COMPAQ.com>
Sent: Tuesday, April 16, 2002 12:16 PM
Subject: RE: [thelist] SQL Question - 'Contingent Columns'
> Hi Rudy,
I know you wrote this to Rudy, but I'm going to respond anyway. :)
> I was hoping there might be some odd 'decode' syntax that might let me
define the value in a selected column by referencing another ... something
like "select (if "AP, then col2 ... if "NA", then col3) as yesterday".
The Case...When syntax does just that. I don't know the Oracle syntax, but
that is a place to start.
-joshua
More information about the thelist
mailing list