i am working on arcsde with oracle 12c can any one tell me where i can get st_geometry into lat long in Oracle 12c?? because in oracle, its shows only st_Geometry from geometry table. How do I generate a list of X,Y (projection WGS 1984) values from a geometry in Oracle / SDE?
arcgis 10.2 enterprise-geodatabase arcsde oracle 12c st_geometry latitude and longitude
PFA
How can i get st_Geom XY from sql developer(Oracle 12c)??
Have you configured the ST_Geometry function yet?
Configure the extproc to access ST_Geometry in Oracle—Help | ArcGIS Desktop
Once you have that confirmed you can look at this: SQL functions used with ST_Geometry—Help | ArcGIS Desktop
When you run this SQL, what are the results?
select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;
Try logging in as the SDE user and running that query. If it does not return something like this:
SDE.ST_ASTEXT(SDE.ST_GEOMETRY('POINT(1010)',0))
--------------------------------------------------------------------------------
POINT ( 10.00000000 10.00000000)Then you need to get it configured correctly first, then you can use the SQL functions to extract the X/Y as needed.
How To: Check if the Oracle extproc is set up correctly for direct ST_GEOMETRY SQL queries
Doing from the ArcGIS side is an option?
Add XY Coordinates—Data Management toolbox | ArcGIS Desktop
Calculate Geometry Attributes—Data Management toolbox | ArcGIS Desktop
How To: Calculate latitude and longitude for point features