SQL IS NULL and IS NOT NULL operator | Oracle SQL fundamentals
#SQL Null check is performed using either IS NULL or IS NOT NULL to check whether a value in a field is NULL or not.
When a #field #value is NULL it means that the #database assigned nothing in that field for that row. The NULL is not zero or blank. It represents an unknown or inapplicable value. It can’t be compared using AND / OR logical operators. The special #operator ‘IS’ is used with the keyword ‘NULL’ to locate ‘NULL’ values. #NULL can be assigned in both type of fields i.e. numeric or #character type of field.
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis