This content has been marked as final. Show 5 replies
No. Because we have no idea what X and Y are nor your Oracle version number.
For all we know X is measured in meters and Y in radians.
That would depend on what co-ordinate system you use for (x,y). Without knowing that, it would be impossible to come up with the conversion.
Please also refrain from using all Caps in your post/subject line.
hi i need to convert x,y coordinates (WGS84 cooridnate system) into Latitude and Longitude and vice versa
i have download one tool from net, it is giving the following Result
X=675555.07(EASTING) IN METERS
Y=2729694.91(NORTHING) IN METERS
Longitude=40.7349667 in Decimal
Latitude=24.6715992 in Decimal
I NEED FORMULA for converting in ORACLE 10g.
There is no standard formula for such conversions, as converting from one coordinate system to another is often a complex mathematical formula. What you need to do is track down (via the internet) the mathematical formula you require for your conversion and then apply that formula as SQL or PL/SQL code. You can pretty much do any mathematics in Oracle code, but firstly you need to know the maths required (and so would we if you expect us to help you).
Perhaps one place that could help you is the Ordnance Survey site...