Oracle PL/SQL: Check If BLOB or CLOB is Empty

Oracle PL/SQL: Check If BLOB or CLOB is Empty

In Oracle PL/SQL, to check if BLOB or CLOB is empty or not, use the dbms_lob.getlength() function or dbms_lob.compare() function. Here are the examples: 1. Using dbms_lob.getlength() Function declare vblob blob; Cursor c_blob is select content into vblob from employee_docs…