Skip to Main Content
Forums

Database Software

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!

Get gtype from geometry

user11219778Aug 12 2013 — edited Aug 13 2013

Hi,

I am unable to find geometry type from Geometry. I have tried following and getting invalid identifier (ora-00904) error. please help!

select geometry.gtype from table1   -- returns invalid identifier

same error using

select geometry.sdo_gtype from table1

select geometry.sdo_srid from table1

however I can query select geometry from table1
This post has been answered by Barbara Boehmer on Aug 12 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2013
Added on Aug 12 2013
#database-key-features, #spatial
2 comments
4,961 views