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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788398425, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL-Plus/set/long/index(68): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

SQL*Plus: SET LONG

Example

See also