NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
use Perl Log In
djberg96 (2603)
djberg96
(email not shown publicly)
(email not shown publicly)
Tuesday July 13, 2004
02:39 PM
Oracle and empty strings
Due to some snafu with regards to NULL and Hibernate, the PM asked me to change all instances of NULL for a particular column to ''. Don't look at me, man, I just work here.
So anyway, update some_table set foo = '' where foo is null, right?
BZZT! Little did I know that '' becomes NULL in Oracle. Who knew? Well, I know now. We ended up using ' ' (a single space).
I blame all computer programming languages for confusing me.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Full
Abbreviated
Hidden
Loading... please wait.
--Larry Wall in stab.c from the perl source code
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
NULL is broken (Score:1)
Re:NULL is broken (Score:2)
Imagine this... (Score:1)
We inherited a 3rd party application. ALL tables are NOT NULL. And those tables that are "blank" are padded with SPACES! That is around 1400 tables. I could shoot the original DBA.