I'm writing
this solution for everyone having
issues doing case insensitive sorts
in Oracle 9i and Oracle 10g.
I was getting results in the
following manner:
This will
return results in the following
manner:
ACME
BAKER Supply
Acme
Baker Supply
etc...
All the solutions I have found
on the Internet have you setting a
session parameter in SQL Plus. Well
that's fine if I'm having my users
run their queries in SQL Plus.
I needed a solution that works
in Oracle Reports and Discoverer,
etc.
I found doing an order
by in the following way:
order by
NLS_UPPER(COL1, 'NLS_SORT =
GENERIC_BASELETTER')
This will return results in the
following manner:
Acme
ACME
Baker Supply
BAKER Supply
etc...
