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
Received on Wed Nov 14 2007 - 00:29:23 CST
