Oracle DataBase convert package.
1️⃣ Converting Blob to Clob
FUNCTION blob2clob (p_blob IN CLOB) RETURN CLOB;
2️⃣ Converting Clob to Blob
FUNCTION clob2blob (p_clob IN CLOB) RETURN BLOB;
3️⃣ Converting Blob to Clob with charset using DBMS_LOB package
FUNCTION blob2clob_cs(p_blob IN BLOB
p_charset_id IN INTEGER DEFAULT DBMS_LOB.DEFAULT_CSID) RETURN CLOB
4️⃣ Converting Clob to Blob with charset using DBMS_LOB package
FUNCTION clob2blob_cs(p_clob IN CLOB,
p_charset_id IN INTEGER DEFAULT DBMS_LOB.DEFAULT_CSID) RETURN BLOB;
ℹ️ Selecting p_charset_id
SELECT VALUE, NLS_CHARSET_ID(VALUE)
FROM v$nls_valid_values
WHERE PARAMETER = 'CHARACTERSET'
 |
 |