Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a row
Try this:
delete from <thetable>
where <clobcol> is null or dbms_lob.getlength(<clobcol>) = 0;
Received on Tue Apr 04 2006 - 16:50:03 CDT