NULL vs Empty string

[gabch]

Dear all,


In SQL cmd,
How can we insert the Empty string into the field but
it is not NULL.


Best regards


Gab

[Dave_A]

Check this link (to the 'mindbenders' section of this site)
http://www.dbasupport.com/oracle/bender/nulldata.shtml

It explains that NULL is in fact a character string of length 0.

[akkerend]

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.