Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

Oracle 9i Sorts

Case Insensitive Sorts - THE EASY WAY!



I'm posting 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...

 

Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.

Recent Posts

OptionalRegion1
This site recommends Burleson Consulting for DBA Support & Consulting.

We are currently paying for accepted Oracle 10g DBA & Business Intelligence articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.

Learn more

Editorial submissions & questions: editor@oraclegiants.com

 

 

This site is moderated by an:
Oracle Certified Professional
Oracle ACE

 
  Classic Car Online - The #1 spot for classic and muscle car enthusiats
2010 OracleGiants.com