oracle-spatial-CodePudding

Tags > oracle-spatial

09-09OSCreating a Cross-Schema Spatial Index in Oracle impossible with single user?
09-06EnterpriseHow to create Oracle Spatial Index?
08-12Back-endSwitch coordinates (X with Y) in SDO_ORDINATE_ARRAY
07-06Software designWhy does CROSS JOIN LATERAL break up array's SDO_GEOMETRY object into individual attributes?
06-21NetConvert MDSYS.ST_LINESTRING subtype value to MDSYS.ST_GEOMETRY supertype
06-21NetGet point geometries as rows for each vertex in SDO_GEOMETRY line
06-20BlockchainWhy does (SHAPE).SDO_ORDINATES(1) syntax fail, but (SHAPE).ST_PointN(1) succeeds?
06-20Software designWhy do we need to Treat() MDSYS.ST_GEOMETRY as ST_LINESTRING to use ST_PointN(1)?
06-15otherCross-joining with a table object propagates rows (without needing Table() function)
06-12Back-endWhy does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in SQL?
06-12EnterpriseWorking with SDO_GEOMETRY ordinates as a table in a column subquery
06-10databaseWhy does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in an SQL query?
06-09OSReplace value in SDO_ELEM_INFO_ARRAY varray
06-09OSLook up SDO_GEOMETRY validation error code using SQL
06-04databaseUtilize function-based spatial index in SELECT clause
06-01Back-endDetermine what rows are causing error in query
05-20front endWhat does the MD in Oracle's MDSYS stand for?
05-20front endIs In-Memory a extra-cost option? (Oracle)
05-17otherTreat Oracle subtype as supertype
05-05Back-endConvert SDO_GEOMETRY's sdo_point attribute to text
05-04Software designConvert VARRAY to text (for concatenation)
04-18Software engineeringModify object attribute/property — without creating custom function
04-08Software designCreate line geometry from lat long
12-08databaseORA-13249: SDO_NN cannot be evaluated without using index
10-14OSOracle Spatial question: can SDO_ORDINATE_ARRAY be populated using query results from another Oracle