boolean NOT does not work in where clause
Posted on 2011-04-21
I have an sql statement in PL/SQL that is not working as expected.
where key = value
and column_q = variable_w
and column_t = variable_p
and column_a in (a,b,c,d,x)
and NOT (column_a = x and column_b = y);
The statement compiles but the "NOT (column_a = x and column_b = y)" does not work.
Can you help me with the proper syntax for this condition?