Oracle Sdo_geometry Tostring()?

I have a .Net system that I am writing which needs to be able to retrieve an oracle geometry field from the database. Is there any way in my SQL statement to cast the geometry type

Solution 1:

You could use the Get_WKT method:

Returns the well-known text (WKT) format (explained in Section 6.7.1.1) of a geometry object.

The documentation gives the following example:

SELECT c.shape.Get_WKT()
  FROM cola_markets c WHERE c.name ='cola_b';

C.SHAPE.GET_WKT()                                                               
--------------------------------------------------------------------------------
POLYGON ((5.01.0, 8.01.0, 8.06.0, 5.07.0, 5.01.0)) 

The return type is CLOB.