Clever Geek Handbook

SQL developer does not query rows for views

I am using developer version of SQL 4.0.3.16

and Java JDK (TM) Platform 1.7.0_71

, (Windows 7 OS)

When I execute a query like select * from table_name

, the query fetches rows.

But if I try to get rows from the view select * from view_name

, the query gets 0 results even though the view is pulling records.

I confirmed this by running the same query on another machine with the same db connection .

What could be wrong with my car settings. I tried to delete the folder completely \AppData\Roaming\sqldeveloper

and start SQL developer again by deleting and creating new connections.

Any suggestions in this regard would be much appreciated.

+3


source to share


2 answers


I had a similar problem a few days ago while trying to output a view. I prefix the view with a schema. This worked for me. Hope this helps.



select * from schema.view;
0


source


There are two possibilities.



  • you need to check read access for you or not.
  • Compile your opinion and check. Since sometimes some columns are removed from the tables that we use in view.it means that the view is now invalid.
0


source






More articles:


All Articles