sql - Case insensitive searching in Oracle - Stack Overflow

The default behaviour of LIKE and the other comparison operators, = etc is case- sensitive.

stackoverflow.com