views:

2564

answers:

2

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?

+3  A: 
SQL> set long 30000
SQL> show long
long 30000
Anonymouse
A: 

This is great solution compared to all other complex solutions provided which requires creating procedures etc.

Thanks