How to perform case-insensitive search in Oracle?

How do you do a case-insensitive search 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 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 cases insensitive?

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

How do I change case-sensitive in Oracle?

By default, Oracle identifiers (table names, column names, etc.) are case-insensitive. You can make them case-sensitive by using quotes around them (eg: SELECT * FROM "My_Table" WHERE "my_field" = 1 ).