Oracle Database Handling NULL values

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Introduction

A column is NULL when it has no value, regardless of the data type of that column. A column should never be compared to NULL using this syntax a = NULL as the result would be UNKNOWN. Instead use a IS NULL or a IS NOT NULL conditions. NULL is not equal to NULL. To compare two expressions where null can happen, use one of the functions described below. All operators except concatenation return NULL if one of their operand is NULL. For instance the result of 3 * NULL + 5 is null.

Remarks

NULL can't appear in columns restricted by a PRIMARY KEY or a NOT NULL constraint. (Exception is a new constraint with NOVALIDATE clause)



Got any Oracle Database Question?