Explanation of a BLOB and a CLOB

sql oracle blob sqlplus clob
Randy picture Randy · Sep 27, 2011 · Viewed 8.1k times · Source

I am looking for a real good explanation of a BLOB and CLOB data. I am looking for the great of that explains in plain English.

Answer

Bart K picture Bart K · Sep 27, 2011

BLOB's (Binary Large OBject) store binary files: pictures, text, audio files, word documents, etc. Anything you can't read with the human eye. You can't select them via SQL*Plus.

CLOB's (Character Large OBjects) store character data. They are often used to store XML docs, JSON's or just large blocks of formatted or unformatted text.

Related questions

How do I get textual contents from BLOB in Oracle SQL

I am trying to see from an SQL console what is inside an Oracle BLOB. I know it contains a somewhat large body of text and I want to just see the text, but the following query only indicates that …

Read More
dbms_lob.getlength() vs. length() to find blob size in oracle

I'm getting the same results from select length(column_name) from table as select dbms_lob.getlength(column_name) from table However, the answers to this question seem to favor using dbms_lob.getlength(). Is there any benefit to using …

Read More
What is it exactly a BLOB in a DBMS context

What is it a BLOB? How can I use it? What are the differences between DBMS's BLOBs. I would like to save data using BLOBs into any DBMS and then read that BLOB with a library.

Read More