|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.