It may be caused by NLS settings
(NLS_SORT, NLS_LANG, NLS_COMP)
Oracle SQL Developer has NLS settings that may differ from results given
by code run on DB server by JDBC for example
so this is first idea for possible reason
Andrej Hopko
On 9. 6. 2010 12:08, Santana 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
