Is there a way in Oracle to make a column not case sensitive?
I want to select rows from a table called `Users` where the column `Logon` is equal to `"foo"` - However, I also want to return `"Foo"` or `"FOO"`.

I could do something like:

    SELECT Id, Name FROM Users WHERE UPPER(Logon) = 'FOO';

And then convert my parameter to uppercase.  However, in our code we have literally hundreds of spots where we'd have to update this.

Is there a way to make the table schema itself case-insensitive so these queries will just work without modification?  Thanks!
Is there a way in Oracle to make a column not case sensitive?
===

I want to select rows from a table called `Users` where the column `Logon` is equal to `"foo"` - However, I also want to return `"Foo"` or `"FOO"`.

I could do something like:

    SELECT Id, Name FROM Users WHERE UPPER(Logon) = 'FOO';

And then convert my parameter to uppercase.  However, in our code we have literally hundreds of spots where we'd have to update this.

Is there a way to make the table schema itself case-insensitive so these queries will just work without modification?  Thanks!