Link to home
Start Free TrialLog in
Avatar of Farzad Akbarnejad
Farzad AkbarnejadFlag for Iran, Islamic Republic of

asked on

Query Syntax

Hello,
I have a numeric field in my oralce table contains the following values:

x
-----
12.55
875.69
325.6
2.53
12.56
....
....

I want to write query to get the following values according to x in y numeric field.

y
------
55.12
69.875
6.325
53.2
56.12
.....
.....

It means I want to replace numbers before decimal point by numbers after decimal point and vice versa.

Thanks
-FA


ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial