PKG_CONVERT

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'