Search code examples
oracle-databaseblobsqlpluscloblob

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


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?


Solution

  • SQL> set long 30000
    SQL> show long
    long 30000