In SQL cmd,
How can we insert the Empty string into the field but
it is not NULL.
Check this link (to the 'mindbenders' section of this site)
It explains that NULL is in fact a character string of length 0.
Oracle makes no difference between NULL and an empty string. In the future Oracle may comply to the aspect of the ANSI SQL 1992 standard, that empty strings are not equivalent to NULL. Oracle even recommends not to treat empty strings and NULL as the same. The problem is, there is no difference in Oracle.
Click Here to Expand Forum to Full Width