sql - Oracle DB: How can I write query ignoring case?

Question

As I had written in title, I have SQL query, run on Oracle DB, lets say:

SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe'

If I would like, that the query would return either "IGNORECASE", "ignorecase" or combinations of them, how can this be done?

Answer 1

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

Alternatively, substitute lower for upper.