Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Single row function

Single row function

From: Rosh157 <kouroshsaei_at_gmail.com>
Date: Wed, 14 Nov 2007 15:39:04 -0800
Message-ID: <1195083544.183663.20710@v2g2000hsf.googlegroups.com>


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 - 17:39:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US