Skip to content

Instantly share code, notes, and snippets.

Created Feb 27, 2012
What would you like to do?
decode(trim(col),NULL,NULL,col) is NULL
-- Do not use null to represent a value of zero, because they are not equivalent.
-- Note: Oracle Database currently treats a character value with a length of zero as null.
-- However, this may not continue to be true in future releases, and Oracle recommends that
-- you do not treat empty strings the same as nulls.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment