4. Understanding the Elements of SQL Statements : SQL Operations : Assignment Operations : Null Value Assignments
 
Share this page                  
Null Value Assignments
A null can be assigned to a column of any data type if the column was defined as a nullable column. A null can also be assigned to a host language variable if there is an indicator variable associated with the host variable.
To ensure that a null is not assigned to a column, use the IFNULL function.