How do you do a case-insensitive search in Oracle?

How do you write a case-insensitive query in Oracle?

If you're on Oracle Database 12.1 or earlier, you can use the session parameters nls_comp and nls_sort to enable case-insensitivity.

How do you make a search case-insensitive?

By default, searches are case-insensitive. You can make your search case-sensitive by using the case filter. For example, the following search returns only results that match the term HelloWorld . It excludes results where the case doesn't match, such as helloWorld or helloworld .

How do you do a case-insensitive search in SQL?

Case insensitive SQL SELECT: Use upper or lower functions or this: select * from users where lower(first_name) = 'fred'; As you can see, the pattern is to make the field you're searching into uppercase or lowercase, and then make your search string also be uppercase or lowercase to match the SQL function you've used.

Are Oracle queries case-sensitive?

Oracle Text supports case-sensitivity for word and ABOUT queries.