question

barikhan avatar image
barikhan asked

Result difference in Oracle 11.2.0.3.0 vs 11.2.0.2.0

Hi All.... I have an issue with a select query. It behaves differently in Oracle 11.2.0.3.0, it works fine in 11.2.0.2.0. SELECT SET_ID, SET_NAME FROM ADB WHERE ROWNUM < 10 ORDER BY SET_ID DESC. I have total of 100 records. This query works fine in 0.2 version returning top 10 records where as in 0.3 it returns bottom 10 records ordering it in descending order.
oracleversion
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.