Re: Single row function

Rosh157 wrote:
> Hello:
> i'm kind of new in Oracle and now learning how to use the Sql*Plus. i
> have question about
> Single functions and i hope that somebody can help me.
> my question is:
> I using Sql*Plus on oracle 10g, and I want to use the "Single row
> function" to create a list of books, I have to increase a price of
> each books based on books category. For example for computer books
> 10%, for fitness books 7%, and for cooking books 25%. And price
> should
> be display with 3 decimal places. (we have a price, title, category,
> and retail price column).what function should be use and if I have to
> use the nesting function how can I apply that.
> Thanks

There is no such thing in Oracle as the "Single row function."

It seems to me you might want to look at the CASE function: http://www.psoug.org/reference/decode_case.html#case

and if that doesn't solve the problem work on providing greater clarity when asking questions.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org