Oracle DB: How can I write query ignoring case?

February 27, 2023 by Tarik

Select * from table where upper(table.name) like upper('IgNoreCaSe');

Alternatively, substitute lower for upper.