newbie needs help badly!!! TIA!
From: <j_at_j.com>
Date: Mon, 10 May 2004 07:00:23 GMT
Message-ID: <3h9u90dt4df4thmr8la5bic4g1bdssajon_at_4ax.com>
Date: Mon, 10 May 2004 07:00:23 GMT
Message-ID: <3h9u90dt4df4thmr8la5bic4g1bdssajon_at_4ax.com>
[Quoted] I am trying my hardest to make this work. Could some one please help a newbie???
What I am trying to accomplish is.
1.) Display 4 Headings, Title, Category, Current Price and Revised Price.
2.) Format the results to $999.99
3.) Calculate the revised price field using the Decode function.
I do not want the DECODE field to show in any of the headings.
THANK YOU
--11
SELECT title "Title", category "Category", TO_CHAR(retail,'$999.99')
"Current Price", DECODE(category,'COMPUTER', .10,
'FITNESS', .15,
'SELF HELP ',.25,
.03)"Sales Increase",TO_CHAR(retail * "Sales Increase",'$999.99')"Revised Price" FROM books; Received on Mon May 10 2004 - 09:00:23 CEST