How to visualize properly BLOB on Oracle SQL?

I have BLOB columns in an Oracle Database that come from an IBM AS400 Database.

The raw data look like (this is litterally what i have from my column (for column Data Type and and a row value)) :

(BLOB)

I’m looking to visualize these BLOBs in a simple query. I mainly used these two methods :

SELECT
    DBMS_LOB.SUBSTR(<BLOB_OBJECT>, 4000, 1) AS DBMS_SUBSTR_4000,
    UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(<BLOB_OBJECT>, 2000, 1)) AS VARCHAR2_SUBSTR
FROM
    <BLOB_TABLE>;

Here the result :

The result should look something like this (to be precise, the example below shows values coming from an AS400 database before being incorporated into an Oracle database) :

I have tried various methods to properly display these BLOB objects. I want to copy the table containing BLOBs into a new table, but without the BLOB data. Instead, I want to convert the BLOB values.

You need to sign in to view this answers