I am enrolled at the Art Institute of Pittsburgh - Online working towards a Bachelor of Science in photography.
My other blog [blogspot.com]
Today is another one of those days.
I'm doing a query against a table using a primary key and a check if two of the other columns are not the same.
SELECT column_list FROM table_name WHERE pk_column = some_var AND column_x != column_y;
One of the columns can be null. Apparently I have never tried to do this with Oracle until now.
Initially I expected that NULL is not equal to some non-NULL value in the same way that an undef is not equal some defined value. However, I know why Oracle does this (it's in the ANSI standard but no one else that I know of does it this way).