DECODE
From: Sherman H. <shung_at_earthlink.net>
Date: Thu, 01 Apr 2004 22:21:28 GMT
Message-ID: <IB0bc.11653$lt2.6400_at_newsread1.news.pas.earthlink.net>
[Quoted] I have to run a query to give a column a value based on a time range. Can I use DECODE?
Date: Thu, 01 Apr 2004 22:21:28 GMT
Message-ID: <IB0bc.11653$lt2.6400_at_newsread1.news.pas.earthlink.net>
[Quoted] I have to run a query to give a column a value based on a time range. Can I use DECODE?
[Quoted] [Quoted] select decode(trans_date, trans_date>='01-Jul-2002' and
trans_date<='30-Jun-2003','Fiscal2002', .....) as fiscal,
from. . .
where. . .
Received on Fri Apr 02 2004 - 00:21:28 CEST