The full contents of the bind-variable are not displayed in SQL Plus

oracleoracle-11gsqlplus

I wrote a big query in bind-variable. I want to print it in SQL Plus, but the text doesn't show, only small part of it.

enter image description here

Best Answer

The length of a CLOB output is limited. You can increase the limit with set long n, example:

set long 50000