SELECT recordid, DBMS_LOB.substr(blobunicode, length(blobunicode), 1) b64hex FROM tblblobjob WHERE length(blobunicode) BETWEEN 1 AND 10) AND DBMS_LOB.substr(blobunicode, length(blobunicode), 1) LIKE '20%'
In explanation, the DBMS_LOB package reads what it can grab from the blob column and produces a readable string from the base64 content. After reading several articles, I'd previously attempted to convert the BLOB to RAW, then to hexadecimal via the UTL_ENCODE package and whatnot. As it turns out, the solution was much simpler than visualised.
No comments:
Post a Comment