oracle-spatial

16 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Why do we need to Treat() MDSYS.ST_GEOMETRY as ST_LINESTRING to use ST_PointN(1)?
user_55767710
•
1
1
74
oracle-spatial oracle18c oracle sql
Collapse vertex rows into nested table type (aggregated by ID)
user_55767710
•
2
1
70
oracle-spatial oracle18c oracle sql
Cross-joining with a table object propagates rows (without needing Table() function)
user_55767710
•
2
1
76
oracle-spatial object-type oracle18c oracle sql
Why does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in SQL?
user_55767710
•
3
3
143
oracle-spatial oracle18c oracle attributes sql
Get XY coordinates from GEOM_SEGMENT_START_PT() output
user_55767710
•
1
3
159
oracle-spatial coordinates oracle geometry sql
Utilize function-based spatial index in SELECT list
user_55767710
•
1
4
114
oracle-spatial spatial-index oracle18c indexing oracle
Custom aggregate function to collapse vertices to SDO_GEOMETRY
user_55767710
•
1
3
135
oracle-spatial aggregate-functions plsql oracle geometry
Create line geometry from lat long
user_10032220
•
1
1
110
oracle-spatial plsql oracle sql
sdo_relate ORA-13343: a polygon geometry has fewer than four coordinates
user_137110770
•
2
1
105
oracle-spatial spatial-query oracle sql
ORA-13249: SDO_NN cannot be evaluated without using index
user_146863020
•
3
2
211
oracle-spatial oracle11g oracle10g oracle
Hot Questions