USING NULL

    This will gives the output based on the null values in the specified column.

     Syntax:

         select * from <table_name> where <col> is null;

     Ex:

         SQL> select * from student where marks is null;

         NO NAME            MARKS

         ---  -------           ---------

         3   Ramesh

         4   Madhu

         5   Visu

         6   Rattu