Settings that are useful in SQL*Plus:

useful
for
term?
useful
for
script?
PAGESIZE 50000 Y Y Don't repeat the column header. Only display it once, at the top.
PAGESIZE 0 ? Don't display the column header at all.
LINESIZE 32767 ? Y Disable line-wrap.
TIMING ON Y Display how long each query takes to complete (shown after completion).
COLSEP ',' Y An easy way to generate CSV files.
ECHO OFF Y like @echo off

See also: