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

    goodluck247

      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. 10.2.0.2.0) and SQL DEVELOPER (v.4.1.5.21) are connected to the SAME database (10g EE 10.2.0.1.0).

       

       

      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