Oracle select case sensitive

quinnd6

Hi
Im sending a select sql statement to oracle using sql plus.

Im searching for a certain word and if it doesnt exist in the table then an error comes up.

Problem is it is case sensitive.

How can I make it so it ignores the case?

is_that_so

quinnd6 wrote:

Hi
Im sending a select sql statement to oracle using sql plus.

Im searching for a certain word and if it doesnt exist in the table then an error comes up.

Problem is it is case sensitive.

How can I make it so it ignores the case?

You can always wrap the variable using lower
For example

select address,id from table where lower(inputname)=lower(table.name);

stipey

I find that google is good for these types of questions. You will probably get an answer quicker than waiting for somebody to read and respond to your post.

Also, Oracle have excellent documentation on their website - oracle.com