I'm writing a SQL on an Oracle database using "ST_Intersects" function. But I get an error which is not important anymore. Because I solved it with deleting some data.
However, I would like to know if there is a validation function for geometry columns in st_geometry functions. Just like PostGIS's ST_IsValid
Check if the below info helps:
A geometry inserted into an Oracle database using the spatial type (an ST_Geometry column) will always be valid because ArcSDE always validates this type of spatial data before accepting it. Other DBMS vendors may not validate the input, but require the application to do so.
Thank you for your response. I forgot to mention that SDE version I'm working on is 10.3.1. Besides all the tables were created and edited through ArcMap or applications built with ArcGIS API. However, I still had a problem with it.