Oracle 集合处理sql
2020-04-04 本文已影响0人
没见过的颜色
/根据一组坐标+半径+生成的坐标精度生成一组圆形集合数据/
SELECT SDO_UTIL.CIRCLE_POLYGON(114.0632144810, 22.5437839740, 1000, 1) FROM DUAL
/将集合转换列函数/
select substr(x,0,10) x, substr(y,0,9) y,0 as z from DUAL a,table(sdo_util.getvertices(SDO_UTIL.CIRCLE_POLYGON(114.0632144810, 22.5437839740, 1000, 1))) c