I am using SQL Developer Version 220.127.116.11 and jdk Version Java(TM) Platform 1.7.0_71 , (OS Windows 7)
When I am executing a query as " select * from <table> " , the query is fetching rows
but if I try to fetch the rows from a view " select * from <view_name> " the query is fetching 0 results even if the view is pulling records.
This I have confirmed by running the same query in different machine with same db connection
What could be possibly wrong with settings in my machine.
I have tried by completely deleting the \AppData\Roaming\sqldeveloper folder and running the sql developer again , deleting and creating the new connections.
Any suggestions in this regard will be highly appreciated.
I've a doupt that connected to setting of SQL Developer, more likely some row security or wrong connection/view details (trying ro fetch data from view with the same name from another schema).
At least could you please performe simple test " select count(*) from <view_name> ".