Update in decimal
Hello if anyone can help thanks.
I have a Products table and a field called price.
There are already records in the table where prices are with broken values
example:
10.8888
11.2548
100.2348
I need everything that comes after the point(.) becomes zero. example
10.8888 to 10.0000
11.2548 to 11.0000
100.2348 to 100.0000
What would be the command to update that way on all products of my table?
Thank you in advance
Subject
Written By
Posted
Update in decimal
March 25, 2015 09:52AM
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.