Re: BLOB

From: Dirk Tschentscher <dirk.tschentscher_at_volkswagen.de>
Date: Thu, 31 Oct 2002 12:44:05 +0100
Message-ID: <apr8ql$ol53@doiweb4.volkswagen.de>

Hi
what about dbms_lob.getlength(blobfield). this function returns null when the field is null

rgds

Dirk

"acelestial" <acelestial_at_twp.cwellington.on.ca> schrieb im Newsbeitrag news:MvYv9.124$896.10833975_at_radon.golden.net...
> Hi,
>
> How do I check if a blob field is empty or null?
> I want to update a column where the blob field is not null.
> I tried IS NOT NULL but it keeps on updating all the records.
> My syntax is:
> UPDATE table
> SET column1 = 'something'
> WHERE blobfield IS NOT NULL;
>
> Any help is much appreciated.
>
> Thanks,
> Arman
>
>
Received on Thu Oct 31 2002 - 05:44:05 CST