How do I display the full content of LOB column in Oracle SQL*Plus?

oracle blob sqlplus clob lob
Anonymoose picture Anonymoose · Sep 23, 2008 · Viewed 57.5k times · Source

When I try to display the contents of a LOB (large object) column in SQL*Plus, it is truncated. How do I display the whole thing?

Answer

Anonymoose picture Anonymoose · Sep 23, 2008 
SQL> set long 30000
SQL> show long
long 30000

Related questions

Explanation of a BLOB and a CLOB

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.

Read More
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