In my Oracle database, I have a SQL query that I want to ignore case. See below:
SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe'
So if I want the query to return either "IGNORECASE", "ignorecase" or a combination of them, how can I do that? Would that be possible?