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