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 9.2.0.6

Thanks
Charlotte

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: Null Clob or Isn't it?
  - From: Michael Twaddell
- Re: Null Clob or Isn't it?
  - From: Niall Litchfield

Null Clob or Isn't it?

Other related posts: