Vertica Quick Tip: Empty String Vs. NULL
Jim Knicely, Vertica Field Chief Technologist
May 30, 2018
An empty string ('') is treated as a NULL value in Oracle, while in Vertica an empty string is not treated as a NULL value. So when using Vertica, if you want to indicate that a column value is unknown, be sure to use NULL and not an empty string! In Oracle: Are they the...