Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Good news everyone! The Boards.ie Subscription service is live. See here: https://subscriptions.boards.ie/

Oracle select case sensitive

  • 16-07-2007 12:49PM
    #1
    quinnd6
    Registered Users, Registered Users 2 Posts: 1,559 ✭✭✭


    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?


Comments

  • #2
    is_that_so
    Registered Users, Registered Users 2 Posts: 32,132 ✭✭✭✭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);


  • #3
    stipey
    Registered Users, Registered Users 2 Posts: 273 ✭✭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


Advertisement