René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

set long [SQL*Plus]

set long n
Sets the amount of bytes displayed for clob, long, nclob and XMLType values.
n must be smaller than 2 million.
The default for n is 80.

Storing settings across sessions

Settings (such as serveroutput) can be stored accross sessions with the glogin.sql and/or login.sql file.
See also store.