SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with data compare CI - problem

460176Oct 8 2010 — edited Oct 8 2010

Hi,

I have tableA (id, Name) and tableB (id, Name).

tableA
1 Monday
2 MOnday
3 MONDAY

tableB
1 Monday
2 Tuesday
3 Monday

I want to get the different lines in the table

Select id, Name from tableA
minus
Select id, Name from tableB

what I want to get is
2 Tuesday

Of course I get more. I tried to solve the problem with
ALTER SESSION SET NLS_COMP='ANSI'
ALTER SESSION SET NLS_SORT='BINARY_CI'

but this doesn't work with minus as I wanted it to.

Can anyone help me please.
Thanks

Walter

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2010

Added on Oct 8 2010

8 comments

206 views