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

Question

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?

score 48 · Accepted Answer · answered Sep 23 '08 at 18:21

48

SQL> set long 30000
SQL> show long
long 30000

answered Sep 23 '08 at 18:21

Anonymoose

This with Kevin's answer is what I actually needed. – Aleksander Stelmaczonek Aug 18 '17 at 10:16
1

@KapilVyas You can add the command to your login.sql if you want it to be executed automatically. On Unix systems, that file should be placed in your home directory. – Anonymoose May 14 '18 at 18:37

score 19 · Answer 2 · answered Sep 01 '11 at 15:32

19

You may also need:

SQL> set longchunksize 30000

Otherwise the LOB/CLOB will wrap.

answered Sep 01 '11 at 15:32

Kevin O'Donnell

2 Answers2