Re: BLOB

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Thu, 31 Oct 2002 12:14:26 +0100
Message-ID: <us249q522l3lb1@corp.supernews.com>

You can use the DBMS_LOB.GETLENGTH function. If it returns 0 it's empty.

Peter

"acelestial" <acelestial_at_twp.cwellington.on.ca> schreef in bericht 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:14:26 CST