1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORDER BY Clause issue

Discussion in 'SQL PL/SQL' started by sampige_sbr, Jun 4, 2010.

  1. sampige_sbr

    sampige_sbr Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hello All,

    We arew having an application , which loads the data sequentially. That is for tehe records with Sequence number 3 to be present, we should have the record with sequence number 2. This is taken by ORDER-BY Clause. The application was working fine in 10G but when we migrated from 10G to 11g,
    we are facing an Order By Clause issue. The previous record in the sequnce is Not getting fetched.
    Has anyone faced similar type of issue earlier and if so what was the solution.

    Many thanks in advance.

    Regards
    Rama
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Which release of 11g are you using and what is the query?
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    OP asked the question 2 years back :) . David might not have noticed that.