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.
The length of a CLOB output is limited.
You can increase the limit with set long n
, example:
set long 50000
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityI 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.
The length of a CLOB output is limited.
You can increase the limit with set long n
, example:
set long 50000