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: