sql - To retrieve not null value -

my requirement is

select *  emp  comm not null;

how find not null (or) null values without using null (or) not null keyword.

why want avoid using is null , is not null? that's simplest , logical approach.

if you're determined

where nvl( comm, -99 ) = -99

will give rows comm null assuming comm can never have value of -99.

where comm > -99

will give rows comm not null assuming non-null values of comm greater -99.

it make no sense write query way, however, when can use is null or is not null , end more maintainable query.

Cap