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

On 14 nov, 08:22, Rosh157 <kouroshs... (AT) gmail (DOT) com> wrote:
Not sure what you mean by "Single Functions", I will read
as "Single Row Function".

I suggest you look up the case statement for your books/category
problem.
As for the "should display..." lookup formatting.
All documenation can be found at http://tahiti.oracle.com

Single Row functions can be found in the SQL Reference Manual:
http://download.oracle.com/docs/cd/B....htm#sthref912

Formatting of output in in the very same manual, take a look here:
http://download.oracle.com/docs/cd/B...181.htm#i79330

The Case Expression is -yet again- in the same manual:
http://download.oracle.com/docs/cd/B...4.htm#i1033392