Search notes:

SQL*Plus: Displaying LOB (clob, blob) values

In order to display LOB values (such as CLOBs) in SQL*Plus, it is recommended to set the following values: linesize, long and longchunksize:

select to_clob(rpad('+', 200, '+')) val from dual;

VAL
--------------------------------------------------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

set lines 210
select to_clob(rpad('+', 200, '+')) val from dual;

VAL
--------------------------------------------------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

set long 210
select to_clob(rpad('+', 200, '+')) val from dual;


VAL
--------------------------------------------------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++

set longchunksize 210
select to_clob(rpad('+', 200, '+')) val from dual;

VAL
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SQL*Plus: Displaying LOB (clob, blob) values

See also