将Wkt转换为Oracle几何

本文介绍了将Wkt转换为Oracle几何的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何将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.