Null Clob or Isn't it?

  • From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 7 Sep 2006 03:24:00 -0700 (PDT)

Hi All,

I'm new to working with CLOBs. Any ideas on what I'm
missing here?

My query below returns a non-zero result:

SELECT count(*)
FROM my_table
WHERE clob_column IS NOT NULL
  AND LENGTH(clob_column) = 0;

How can I have a CLOB column of length zero which is
not null?

This is on


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

Other related posts: