Fwd: Null Clob or Isn't it?

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Thu, 7 Sep 2006 04:51:53 -0700 (PDT)
Message-ID: <20060907115153.84261.qmail@web34108.mail.mud.yahoo.com>

Thanks to all who responded both on and off list. Seems there is a distinction between an empty CLOB and a NULL CLOB. I need to stop thinking of CLOBs as just big VARCHAR2s :-)

Thanks
Charlotte

• Charlotte Hammond <charlottejanehammond_at_yahoo.com> wrote:

> Date: Thu, 7 Sep 2006 03:24:00 -0700 (PDT)
> From: Charlotte Hammond
> <charlottejanehammond_at_yahoo.com>
> Subject: Null Clob or Isn't it?
> To: oracle-l_at_freelists.org
>
> 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
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 07 2006 - 06:51:53 CDT