DBMS_LOB

Create function to convert the blob content to clob Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) RETURN CLOB AS l_chunk VARCHAR2 (32767); l_position PLS_INTEGER :=…