将Wkt转换为Oracle几何 [英] Convert wkt to oracle geometry

问题描述

如何将wkt转换为oracle sql 我正在使用:

How to convert wkt to oracle sql I am using:

SELECT SDO_GEOMETRY('POINT(-121.909315288067 37.3618668002592)',4326) as station_geom_oracle FROM dual

我得到了MDSYS.SDO_GEOMETRY

运行:

Java(TM) Platform   1.8.0_151
Oracle IDE  19.1.0.094.2042
Versioning Support  19.1.0.094.2042

推荐答案

我是从另一个问题来到这里的，而您做对了.查询结果只是告诉您已经创建了一个几何对象.无法在表中显示几何对象，因此只能在方括号中给出数据类型.您可以尝试使用SDO_UTILS.TO_WKTGEOMETRY(geom)函数将其转换回WKT以确认它是否正常工作.如果可以，请尝试使用SDO_UTILS.SDO_DISTANCE计算它们之间的距离.

I came here from your other question, and you've done it right. The query result is just telling you that you've created a geometry object. There's no way of showing a geometry object in a table so it just gives the data type in square brackets. You could try converting it back into WKT to confirm that it's worked using the SDO_UTILS.TO_WKTGEOMETRY(geom) function. If that looks ok try using SDO_UTILS.SDO_DISTANCE to calculate distance between them.

这篇关于将Wkt转换为Oracle几何的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！