difference in behavior of sql and pl/sql after migrating from 9i to 11g
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 changeexample :
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
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
0