The Gospel

Today’s lesson is from the book of stackoverflow 65,35-21:

It’s a well known fact, that Oracle treats empty strings as null.

I knew about that, but somehow I forgot…

One Comment

  1. Well for all things Oracle, the one source of truth is Tom Kyte. So you probably should quote the place where Tom Kyte and stackoverflow come together:

    http://stackoverflow.com/questions/203493/why-does-oracle-9i-treat-an-empty-string-as-null/203551#203551

    Which says almost the same as your quote in most cases but is just a little more precise.

Leave a Reply