How to query a FeatureClass in Oracle SQL Developer?

Question

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.

ShaningYu · Answer

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.

JoshuaBixby · Answer

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

Asrujit_SenGupta · Answer

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