SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Spatial query

Gor_MahiaJul 14 2025 — edited Jul 14 2025

Hi,
ive geometry data as shown below stored as clob type.

SDO_GEOMETRY('LINESTRING(3.141592653589793 -6.283185307179586,2.718281828459045 -1.414213562373095)') as lines,
SDO_GEOMETRY('POLYGON((-8229299.84927481 4984122.34830465,-8229278.20206954 4984107.71646436,-8229265.81091066 4984124.19504177,-8229288.05528022 4984139.96333566,-8229299.84927481 4984122.34830465))') as polygon,
SDO_GEOMETRY('POINT(-8232851.16610483 4984795.91812851)') as points

i want to display these dataset as langitude and longitudes etc (e.g split into coordinates).

12c Enterprise Edition

thanks.

Added on Jul 14 2025

#pl-sql, #spatial, #sql

5 comments

125 views