-
Dear all,
In SQL cmd,
How can we insert the Empty string into the field but
it is not NULL.
Best regards
Gab
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|