BAZOO

So much to do, so little time

Trying to squeeze sense out of chemical data

Oracle Notes

with 3 comments

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

Written by Rajarshi Guha

October 6th, 2009 at 2:26 pm

Posted in Uncategorized

Tagged with ,

3 Responses to 'Oracle Notes'

Subscribe to comments with RSS or TrackBack to 'Oracle Notes'.

  1. Mark R

    6 Oct 09 at 3:40 pm

  2. 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/

    Pat Walters

    7 Oct 09 at 3:00 am

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

    Rajarshi

    11 Oct 09 at 2:58 pm

Leave a Reply