|
|
|
|||||||
| |||||||
|
|||||||
|
Oracle 9i SortsCase 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...
|
|||
|
Recent Posts
|
||||
|
||||
| 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. Editorial submissions & questions: editor@oraclegiants.com
|
||||
|
This
site is moderated by an:
|
|
|
|
| Internet Child Safety | Internet Startups | CRM Strategy | The Oracle Blog | Traffic Building | Domain Names | The Software Site | Video Games |Free Links |
| 2006 OracleGiants.com |