I've noticed that SQL clients select the SHAPE column from SDE.ST_GEOMETRY in different ways:

select shape from roads where 
  • Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,NULL,NULL,0,0,300051,(BLOB))
  • SQL Developer: [SDE.ST_GEOMETRY]
  • MS Access: Error: Invalid field definition 'SHAPE' in definition of index or relationship. (I know MS Access isn't a real SQL client; but it helps demonstrate the point.)


Why does Toad return a textual representation of the points, when other SQL clients don't?

  • Does Toad use an SDE.ST_GEOMETRY function on the SHAPE column?

(Oracle 12c; ArcGIS 10.7.1)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.