Re: Single row Function Question

On 14 nov, 08:22, Rosh157 <kouroshs..._at_gmail.com> 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

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/B19306_01/server.102/b14200/functions001.htm#sthref912

Formatting of output in in the very same manual, take a look here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions181.htm#i79330

The Case Expression is -yet again- in the same manual: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions004.htm#i1033392 Received on Wed Nov 14 2007 - 05:57:54 CST