Oracle Notes

Some handy settings when running a query from the command line via sqlplus

set echo off
set heading on
set linesize 1024
set pagesize 0
set tab on
set trims on
set wrap off
-- might want to set column formats here
-- e.g.: column foo format A10
spool stats -- dump results to stats.lst
-- SQL query here

spool off
exit

3 thoughts on “Oracle Notes

  1. Pat Walters says:

    Instead of sqlplus you should try yasql, a much more civilized alternative to sqlplus. Yasql has gnu readline support, more flexible output, and lots more.

    http://sourceforge.net/projects/yasql/

  2. Rajarshi says:

    Hi Pat, thanks for the pointer – much nicer than sqlplus

Leave a Reply

Your email address will not be published. Required fields are marked *