Hi one thing the other solutions left out is how to make sure that your queries sort properly regardless of the server's settings. There is a command in 10g and 11g that you can use called "nulls last" or "nulls first"
so select * from emp order by upper(first_name) asc nulls last or select * from emp order by upper(first_name) asc nulls first This will force every query to consistently handle nulls as the first or last item sorted in a sort directive. I recommend this practice because you never know sometimes the differences between servers that you migrate your code to. (as in your own personal example) RG Pascual On Wed, Jun 9, 2010 at 3:08 AM, Santana <paulito.sant...@gmail.com> wrote: > Hi all. > I have a problem that i can't explain. > > > select * from emp > order by upper(first_name) > > This query produce this results on my ORACLE client(PLSQL > Developer) , this oracle client is installed in a laptop that is not > the ORACLE server : > > [ no name ] > 111111111 > Anne Smith > John > Zlako > > > This same query in the database Oracle server machine in the same > client program(PLSQL Developer) produce a complete different resulty : > > Anne Smith > John > Zlako > 111111111 > [ no name ] > > > what is the problem ? there is any parameter that i can change ? > > > Thanks a lot. > Paulito Santana. > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
