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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Oracle select case sensitive

  • 16-07-2007 11:49am
    #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,136 ✭✭✭✭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