Home » Server Options » Spatial » Does Oracle Spatial support floating point coordinates?
Does Oracle Spatial support floating point coordinates? [message #75834] Wed, 28 July 2004 09:26 Go to next message
andi
Messages: 23
Registered: March 2004
Junior Member
In the user's guide and references, it is said that oracle does

not support floating point coordinate unless it's point data.

But when I tried to enter floating point coordinates into some

SDO_GEOMETRY it works, and I could even get floating point

result from a "select intersection" query.

Can anyone give me an explaination?

Thanks.
Re: Does Oracle Spatial support floating point coordinates? [message #75836 is a reply to message #75834] Wed, 08 September 2004 10:27 Go to previous message
Bryan Hall
Messages: 6
Registered: September 2004
Junior Member
Yes, SDO_GEOMETRY coordinates are stored as a "floating point" number. However, you may not get a fractional answer if you set the precision too small.
Previous Topic: something is wrong when i use "sdo_geor.subset"
Next Topic: Trigger to calculate length
Goto Forum:
  


Current Time: Fri May 07 18:38:21 CDT 2021