Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Formatting SQL*Plus output..

Re: Formatting SQL*Plus output..

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Fri, 12 Mar 1999 17:13:24 GMT
Message-ID: <36e94b00.16157926@news.erols.com>


On Fri, 12 Mar 1999 08:53:07 -0000, "Mark Gumbs" <mgumbs_at_hotmail.com> wrote:

>The soultion is suggested by our fellow newsgroup buddies in this thread.
>Only addition is to set pagesize to a high number (like 1000, depends on how
>many rows you expect). Set trimspool on (to take out any white spaces after
>the last column).
>And set heading off.

set pagesize 0;
set linesize 1000;
set trimspool on;
set heading off;
set feedback off;

etc.

Chris



Chris Hamilton -- toneczar_at_erols.com
City of Washington Pipe Band
http://www.serve.com/cowpb/chamilton.html Received on Fri Mar 12 1999 - 11:13:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US