I have a String query;
when i execute this query using SQL DEVELOPER IDE i am getting 34 rows.
But when execute the same query using Statement.executeQuery(query); i get 36 rows.
The extra 2 rows returned are duplicate. I am unable to find the reason for this difference in the result returned by IDE and JDBC.
The target DB is a oracle DB.
Thanks in Advance:(handshake):