Home >Database >Mysql Tutorial >Oracle spatial 空间修正函数（SDO_UTIL.RECTIFY_GEOMETRY）_MySQL
Oracle spatial 空间修正函数（SDO_UTIL.RECTIFY_GEOMETRY）_MySQL
- WBOYOriginal
- 2016-06-01 13:27:061075browse
ORACLE函数
bitsCN.comOracle spatial有个空间修正函数SDO_UTIL.RECTIFY_GEOMETRY，它可以修复以下可能：a、重复节点 b、自相交 c、坐标串朝向不正确。
该函数的构造函数格式：
SDO_UTIL.RECTIFY_GEOMETRY(
geometry IN SDO_GEOMETRY,
tolerance IN NUMBER
) RETURN SDO_GEOMETRY;
使用样列：
SELECT SDO_UTIL.RECTIFY_GEOMETRY(shape, 0.005)
FROM COLA_MARKETS c WHERE c.name = 'cola_b';
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL同步 1032,1062异常_MySQLNext article：数据库优化<二>SQL优化之SELECT优化 ――_MySQL