How to compare 2 tables with some empty fields?

[Hans Claassens]

How do I compare 2 tables with some empty fields?

I fetch one row from the first table and I want to use the fields as params in the second OracleDataset.
When one of these params are NULL it fails.

 

[Marco Kalter]

How exactly do you compare them?

If you are comparing in a where clause, then you must take null values into account. For example:

where (col = :compare_col or (col is null and :compare_col is null))

Comparing with null in SQL or PL/SQL results in null, which is not true (or false).