Timeline for When to use NULL and when to use an empty string?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 29, 2023 at 7:55 | comment | added | Pere | This must refer to an old Oracle version or I've missed something. Since working with Oracle, I can perfectly distinguish between empty or NULL, both when creating the table or when making queries. In fact, I just tried to ALTER a table to change from NULL as default to empty string as default, and 1) it complained the there were NULL values there so I had to manually update to empty strings and 2) that triggered the "Avoid assigning strings of zero length to character-type variables" warning in Toad. If Oracle internally treats both as the same is something I ignore. | |
| S Jun 14, 2018 at 17:04 | history | suggested | T-Gergely | CC BY-SA 4.0 |
I don't think you're example was correct.
|
| Jun 14, 2018 at 15:14 | review | Suggested edits | |||
| S Jun 14, 2018 at 17:04 | |||||
| Jan 4, 2011 at 16:53 | comment | added | Joe | related : stackoverflow.com/questions/203493/… | |
| Jan 4, 2011 at 9:00 | history | answered | bernd_k | CC BY-SA 2.5 |