1 Reply Latest reply on May 18, 2015 9:42 AM by kulikouski

    SQL Developer not fetching rows for views


      Hi All


      I am using SQL Developer Version 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.