1. Introduction
In this article lets look at how to read blob data in Oracle. We will also look how to select blob data in Oracle. BLOB is nothing but a datatype which is used to store the large data.
For storing large data, Oracle Oracle offers the BLOB, CLOB
2. Read Blob Data
Oracle has a utility DBMS_LOB utility which provides many utilities for all relevant BLOB Operations.
SUBSTR utility from DBMS_LOB can be used to convert BLOB to Substr as per the syntax given below.
SELECT DBMS_LOB.SUBSTR(BLOB_FIELD_NAME) FROM TABLE_NAME;
3. Conclusion
To conclude, we’ve seen how to select the data from Oracle BLOB using SUBSTR function of the DBMS_LOB utility .
FAQs
How to Read Blob Data in Oracle?
SELECT DBMS_LOB.SUBSTR(BLOB_FIELD_NAME) FROM TABLE_NAME;