1 2 Previous Next 16 Replies Latest reply on Apr 28, 2017 9:48 PM by rp0428

    SQL*PLUS query results DIFFERENT from SQL DEVELOPER results


      Hello all,


      I have a query which I run against the production database in SQL*PLUS, and I get 171 rows of data.

      When I run the SAME QUERY in SQL DEVELOPER, I get the "no rows selected" message.


      I copy/paste the query FROM THE SAME FILE from NOTEPAD++, it is ABSOLUTELY the same query.

      SQL*PLUS (v. and SQL DEVELOPER (v. are connected to the SAME database (10g EE



      It is a production database with sensitive information, I can't copy it here.


      From your experience, have you ever heard or dealt with such a problem before? What could be causing this, at least theoretically speaking?


      Thank you.

        1 2 Previous Next