判断oracle blob字段是否为空

荒村听雨31

select pic_id ,pic_file from im_gift_jpg a WHERE dbms_lob.getlength(pic_file) > 0;