Set a field same as another
Hi
I want to run a query that will look at the price in one column and set another column a rounded price ie: if column A (the price column) is 2.95 I want to set another column 3 if the price is 2.25 I want to set the other column to 2 is this poss please? in other words the nearer to the whole value and I would it at that.. is it a brain teaser?
Subject
Written By
Posted
Set a field same as another
May 06, 2016 04:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.