How to Read Blob Data in Oracle?

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;