Programming Help

Web Development



What's Here?

  • Members: 137,356
  • Replies: 481,874
  • Topics: 75,122
  • Snippets: 2,568
  • Tutorials: 676
  • Total Online: 1,735
  • Members: 55
  • Guests: 1,680

Welcome to Dream.In.Code
Become an Expert!

Join 137,356 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,735 people online right now. Registration is fast and FREE... Join Now!




nesting functions in oracle

 
 Reply to this topicStart new topic

nesting functions in oracle
raeNet
8 Oct, 2008 - 11:37 AM
Post #1

D.I.C Head
**

Joined: 1 Nov, 2007
Posts: 98


My Contributions
QUOTE
I got the following code to work. It's main purpose was to replace current pricing for a particular book category (COMPUTER) with an increase of 10%.

However, I also need to increase two other book categories, as well. One for 15% and the other for 25%.

Can anyone help me with these other increases? I can only get one category to increase successfully. THX!


CODE

SELECT title, category, TO_CHAR(retail, ‘999.99’) "CURRENT PRICE", REPLACE(retail*1.1, '', '')"REVISED PRICE"
FROM BOOKS
WHERE CATEGORY = 'COMPUTER';


This post has been edited by raeNet: 8 Oct, 2008 - 11:37 AM
User is offlineProfile CardPM
+Quote Post

raeNet
RE: Nesting Functions In Oracle
8 Oct, 2008 - 03:55 PM
Post #2

D.I.C Head
**

Joined: 1 Nov, 2007
Posts: 98


My Contributions
QUOTE
Never mind. I was able to accomplish the task by using another function. Thanks anyway.

User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/5/08 12:56AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month