Slash Boxes
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

Log In

[ Create a new account ]

djberg96 (2603)

  (email not shown publicly)

Journal of djberg96 (2603)

Tuesday July 13, 2004
02:39 PM

Oracle and empty strings

[ #19824 ]
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.
More | Login | Reply
Loading... please wait.