Web Reference: Apr 1, 2021 · Collations are an easy way to find and sort text according to the case and accent rules you want to use. Using the collate operator gives you fine-grained control over the rules you use in any textual comparison (searching, sorting, grouping, etc.). Jun 15, 2015 · First of all, you can order by the UPPER (or LOWER) case of the column, but once you've done that, you then need to sort by the text itself to get the order on the initial letter; eg: This article assumes the following. 1. Your are using Oracle Database 12c Release 2 (12.2). 2. Your MAX_STRING_SIZE parameter is set to EXTENDED. You can see how to do this here. Without this you will see this error, "ORA-43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set." 3. Your COMPATIBLE parameter is set to 12.2o...
YouTube Excerpt: Case Insensitive
Information Profile Overview
Case Insensitive Sorting In Oracle - Latest Information & Updates 2026 Information & Biography
Details: $83M - $100M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 3, 2026
Information Outlook & Future Earnings
Disclaimer: Disclaimer: Information provided here is based on publicly available data, media reports, and online sources. Actual details may vary.