NULL vs Empty string
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: NULL vs Empty string

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    18
    Dear all,


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


    Best regards


    Gab

  2. #2
    Join Date
    Feb 2001
    Posts
    123
    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.

  3. #3
    Join Date
    Jul 2000
    Posts
    296
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width