How do I display the full content of LOB column in Oracle SQL*Plus?
60,916
Solution 1
SQL> set long 30000
SQL> show long
long 30000
Solution 2
You may also need:
SQL> set longchunksize 30000
Otherwise the LOB/CLOB will wrap.
Author by
David Soroko
Updated on July 18, 2022Comments
-
David Soroko almost 2 years
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?