Re: newbie needs help badly!!! TIA!

j_at_j.com wrote:
> 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;
>

Format in SQL*Plus: http://www.psoug.org/reference/sqlplus.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)