Select to view content in your preferred language

How to query a FeatureClass in Oracle SQL Developer?

1508
3
02-21-2017 10:53 AM
ShaningYu
Honored 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.

0 Kudos
3 Replies
Asrujit_SenGupta
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

ShaningYu
Honored 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.

0 Kudos
JoshuaBixby
MVP Esteemed Contributor
0 Kudos