Seems like Oracle comparison operators = and like are case-sensitive  

Without changing the NLS\_COMP:
Is it possible to add a hint per query to make them case-insensitive?

```
something like:    select /*IGNORE_CASE*/ from tab where val like '%noMatTer%'

```

Is it possible introduce/"teach"/code a new hint in the Oracle DB?  

Anything on the query level can be done? (besides the obvious: WHERE upper(user\_name) LIKE '%ME%')