Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |