How do we check null value for Select Statement

[memory]

You can use decode function in select statement & outer join in your defficient column for eg:
select decode(column_name,NULL,'Any String',Column_name or value)
from table_name
where a.column_name(+)=b.column_name;