Case insensitive search in Oracle
Need case and/or accent-insensitive search in Oracle #SQL?
From 12.2 use the COLLATE clause to set the sensitivity of columns or expressions
From 23ai you can use this in domains too:
CREATE DOMAIN ... AS ... COLLATE binary_ci
Note: set max_string_size = EXTENDED to use this!
--
Need help with SQL?
Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg...
Ask us over on AskTOM: https://asktom.oracle.com
Twitter: / chrisrsaxon
Daily SQL Twitter tips: / sqldaily
All Things SQL blog: https://blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/
===========================
The Magic of SQL with Chris Saxon