Posted on 2005-04-12
Last Modified: 2012-06-21
Hi all,

Quite a simple on really, just gave it 500 for quick response.

I'm after a Oracle SQL command such as the following:

select *
from table1
where IGNORE CASE (field1 != field2);
Question by:trickys77
    LVL 76

    Accepted Solution

    select *
    from table1
    where lower(field1) != lower(field2);

    Depending on the size of the table you might need to look at a function based index.

    Author Comment

    yep that works,


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Able to SELECT but not DELETE 4 37
    Oracle View 13 36
    substr - oracle 5 50
    consolidate 4 lines of oracle query output to 1 line 4 25
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now