NEWBIE: conditional query
From: Peter Wenker <peter.wenker_at_mci.com>
Date: 1996/11/19
Message-ID: <01bbd669$c5abc760$ad3c29a6_at_wenker.con.mci.com>#1/1
Date: 1996/11/19
Message-ID: <01bbd669$c5abc760$ad3c29a6_at_wenker.con.mci.com>#1/1
I'm trying to select different values from a DATE field based upon the value of the date. Specifically, I want to query all rows in a table with a DATE field. I want the query to return a value of 'CLOSED' if the date is less than or equal to SYSDATE, and NULL if the date is greater than SYSDATE. Is this possible? I'm familiar with SQL*PLUS but not as familiar with its advanced functionality.
Appreciate any help - thanks - john.sauer_at_MCI.com
(please cc peter.wenker_at_MCI.com)
Received on Tue Nov 19 1996 - 00:00:00 CET