How to query a FeatureClass in Oracle SQL Developer?

639
3
02-21-2017 10:53 AM
Highlighted
Frequent Contributor

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.

Reply
0 Kudos
3 Replies
Highlighted
MVP Regular Contributor

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

Highlighted
Frequent Contributor

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.

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor
Reply
0 Kudos