10 Replies Latest reply: Feb 20, 2012 1:30 PM by user388355 RSS

    difference in behavior of sql and pl/sql after migrating from 9i to 11g

    user388355
      after migrating our database from oracle 9i to oracle11g, the developpers are worry that the behavior of the queries and pl/sql procedures/functions will change
      example :
      in 9i, select salary,count(*) from emp group by salary, it will display the rows sorted by salary
      in 11gi, select salary,count(*) from emp group by salary, it will display the rows not sorted by default, we have to add the clause order by salary.

      somebody could give the list of other difference in behavior (SQL and PL/SQL) agter migrating from 9i to 11g

      Thanks a lot.