topic How to query a FeatureClass in Oracle SQL Developer? in Data Management Questions

How to query a FeatureClass in Oracle SQL Developer?

ShaningYu — Tue, 21 Feb 2017 18:53:45 GMT

The feature classes in my app are stored in our SDE for Oracle DB. In Oracle SQL Developer, I can query tables in the DB. However, I can't run SQL on a FeatureClass, e.g., like the SQL statement below:

SELECT * from myFCName

Is it possible to do such a kind of query? Thanks.

Re: How to query a FeatureClass in Oracle SQL Developer?

Asrujit_SenGupta — Tue, 21 Feb 2017 18:57:20 GMT

Feature Classes are stored in the form of Tables only at the database end. So you should be able to query them the same way as you normally query for database tables.

Try adding the schema owner name and then check: SELECT * from data_owner.myFCName

Re: How to query a FeatureClass in Oracle SQL Developer?

JoshuaBixby — Tue, 21 Feb 2017 19:08:39 GMT

I encourage you to read SQL access to enterprise geodatabase data .

Re: How to query a FeatureClass in Oracle SQL Developer?

ShaningYu — Tue, 21 Feb 2017 20:09:08 GMT

Tried in the same way as you recommended. I have used an alternative approach done this work. What I used is ESRI's ArcDataBinding components (Bind a geodatabase table to a .NET control ). Thanks for your response.