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>


[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

Original text of this message