[thelist] SQL Question - 'Contingent Columns'

[Joshua Olson]

----- 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