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.