Re: BLOB

It returns 0 (zero) if the BLOB is empty (=null).

Peter

"Dirk Tschentscher" <dirk.tschentscher_at_volkswagen.de> schreef in bericht news:apr8ql$ol53_at_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 - 07:21:27 CST