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

    SQL Developer not fetching rows for views

    913642

      Hi All

       

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

       

      Thanks