IS NULL
condition is used to select records with NULL
esteems in a segment. And IS NOT NULL
condition is used to select records which does not have any NULL
values in any columns and can be used in Insert, Delete, Select and Update statement. NULL
values in a column.