Home » SQL & PL/SQL » SQL & PL/SQL » Function that multiple the number when there is more than 3 decimal point (mered by CM) (PL/SQl Developer, XP)
Function that multiple the number when there is more than 3 decimal point (mered by CM) [message #448186] 
Sat, 20 March 2010 06:42 
chester04
Messages: 3 Registered: March 2010 Location: Phil

Junior Member 


Hi All,
Can anyone teach me how to create a function that will multiply the number when the number has more than 3 decimal point.
Example.
123.012  multiply by 10
123.0123  multiply by 100
123.01234  miltiply by 1000
Column A is the result of the number being multiplied according to decimal point.
Column B contains the multiplier used in column A.
Hope somebody will help me.
Thanks in advance.













Goto Forum:
Current Time: Fri Dec 09 02:07:23 CST 2016
Total time taken to generate the page: 0.27847 seconds
