Programmer's Cookbook

When you want to dump data using SQL*Plus to a file you can use the spool command. This also writes all of the special formatting, including column headers ever 10 lines or so. Often you just want the data, and not the extra stuff. The following is a set of SQL*Plus commands that I usually use to surpress all of the extra formatting, and set a column seperator.

set newpage 0
set space 0
set linesize 80
set pagesize 0
set echo off
set feedback off
set heading off
set colsep |