Search notes:

SQL*Plus: SET LONG

SQL> set long n

The value that is set with set long specifies the maximum number of bytes

that are displayed for blob, clob, nclob, bfile, long and xml values
when long values copied using the SQL*Plus command copy

Example

The data type of text in all_views is long.

If selecting text from all_views in SQL*Plus, only the amount of bytes indicated with set long are displayed:

SQL> set long 10
SQL> select text from all_views where view_name = 'SESSION_CONTEXT';
TEXT
----------
select nam

SQL> set long 9999999
SQL> select text from all_views where view_name = 'SESSION_CONTEXT';
TEXT
--------------------------------------------------------------------------------
select namespace, attribute, value from v_$context

See also

set jsonprint (Oracle 21c) defines the maximum length that is displayed for JSON values.

set

Displaying LOB values (such as CLOBs) in SQL*Plus