2 Replies Latest reply: Jan 6, 2013 4:31 AM by fiaz0419 RSS

    ROW_NUMBER()

    970365
      Hi
      I have one report in 10g then migrated 11g.In 10g dont have row_number while checking report DB query.But 11g it write below logic while executing DB query

      ROW_NUMBER() OVER (PARTITION BY D1.c2, D1.c3, D1.c4, D1.c5 ORDER BY D1.c2 ASC, D1.c3 ASC, D1.c4 ASC, D1.c5 ASC) as c7

      How to remove this logic in 11g.
      b'cos in 10g values return 2 duplicated values but 11g it resticted duplicate value b'cos if more than one value return it restrict row_number.