Fwd: Null Clob or Isn't it?
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 7 Sep 2006 04:51:53 -0700 (PDT)
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@xxxxxxxxx>
wrote:
> Date: Thu, 7 Sep 2006 03:24:00 -0700 (PDT)
> From: Charlotte Hammond
> <charlottejanehammond@xxxxxxxxx>
> Subject: Null Clob or Isn't it?
> To: oracle-l@xxxxxxxxxxxxx
>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
