hello, I'm working with a jsp/oracle application.
I'm having trouble with a sql statement whose condition is that the value is null.

For example,
SELECT a, b, c
FROM myTable
WHERE condition = null;

In the table, the condition is either N or null.

I've tried
condition = ""
condition = ''
condition = null
condition = "null"
condition != 'N'
condition <> 'N'

All these do not produce any result, even though there should be at least 50 rows that have null conditions.

Is there anything that I'm not aware of when finding null values? Can anyone help me with this problem?

Thanks a lot!