Oracle Enterprise GeoDatabase Question

[DRae]

Hi I am new to the geospatial analysis. In my environment, there is an Oracle Enterprise GeoDatabase setup for the GIS Server, and Portal. I want to learn how to do the spatial analysis with SQL, I want to know where I can get the document for function like ST_Geometry. Thanks

[Bud]

Did you try googling st_geometry function?

https://www.google.com/search?q=st_geometry+function

https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/st-geometry.htm 

[MarceloMarques]

SQL and enterprise geodatabases—ArcMap | Documentation (arcgis.com)

The ST_Geometry storage type—ArcMap | Documentation (arcgis.com)

SQL functions used with ST_Geometry—ArcMap | Documentation (arcgis.com)

• List of SQL functions

[DRae]

Is it matter that I am using ArcGIS Pro instead of ArcMap for the ST_Geometry? 

[MarceloMarques · Accepted solution]

@DRae - If you plan to use SQL  to access the spatial data stored in the Geodatabase with Esri ST_GEOMETRY Spatial Data Type, then the ArcGIS Client that you use to create or upgrade the ArcSDE Geodatabase Repository "does matter". Why? Because of bug fixes, enhancements, etc. 

Note: ArcMap 10.8.x will retire, and customers need to switch to ArcGIS Pro.

ArcMap Life Cycle | Esri Support

The best practice is to keep the ArcGIS Client version and the ArcSDE Geodatabase Repository Version at the same ArcGIS Version to avoid issues.

Read the details in the link below.

Client and geodatabase compatibility—ArcGIS Pro | Documentation

[Bud · Accepted solution]

I would argue that it doesn't matter. Esri hasn't made any changes to ST_GEOMETRY in years. So, I think the documentation applies to both ArcMap and ArcGIS Pro. And I would be surprised if you're using a version of either that is so old that it doesn't match the docs.

At any rate, here is the ST_GEOMETRY documentation for ArcGIS Pro. As far as I can tell, the content is the same as the ArcMap link.
ArcGIS Pro - Databases and ST_Geometry - See the PDF link at the bottom of that page: https://pro.arcgis.com/en/pro-app/3.0/help/data/databases/pdf/stgeometry_reference.pdf