Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
ORACLE: Empty / NULL
decode(trim(col),NULL,NULL,col) is NULL
-- http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm
-- 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