How you view a BLOB value all depends on your application development platform. SQL*Plus will not let you see BLOB values since SQL*Plus is a text environment and BLOB values are binary data. Also, the BLOB value could be a sound file, or an MPEG movie. SQL*Plus is not able to play sounds or show movies. As such, Oracle has coded SQL*Plus to not show BLOB values.
This Oracle documentation shows a lot of information on BLOBs. Pay close attention to Chapter 6 as it contains information on how to access BLOBs for your specific development platform.
You may need to register for an account to view the document, but registration is free!
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.