This discussion is archived
10 Replies Latest reply: Feb 20, 2012 11:30 AM by user388355 RSS

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

user388355 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points