SQL*Plus: SET

Some options

Some interesting options, IMHO, that can be set, include:

`arraysize`
`autocommit`	Compare with `exitcommit`
`autoprint`
`autotrace`
`blockterminator`
`colinvisible`
`concat`
`define`	The character that prefixes substitution variables. The default is the ampersand (`&`). Using substitution charactes can be turned of with `set define off`.
`echo`	Specifies if commands of a script script being executed with `@`, `@@`, `start` are replicated on the terminal.
`editfile`
`escape`
`exitcommit`	Compare with `autocommit`.
`feedback`	If set to `on`, SQL*Plus will report the number of records that are affected by DML statements or after executing a PL/SQL block, will print `PL/SQL procedure successfully completed.`
`flagger`
`linesize`	Specifies the number of characters that can be displayed in a row.
`lobprefetch`
`long`	Sets the number of bytes that are displayed for `blob`, `clob`, `nclob`, `bfile`, `long` and `xml` values
`longchunksize`
`numformat` and `numwidth`	Specify how numbers are formatted in `select` statement resultset.
`pagesize`
`rowlimit`	If set, the value specifies the maximum number of records that are displayed in a `select` statement.
`rowprefetch`
`serveroutput`
`showmode`	If set to `on`, SQLPlus will print the old and new value of an SQLPlus system variable when modifying it with `set`.
`termout`
`trimspool`
`timing`

The currently active values (either the default values or the ones overwritten with a set command) can be saved into a file with

SQL> store set set-values.sql

Later, this file can be sourced in order to have the same settings again:

SQL> @ set-values.sql