| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Formatting SQL*Plus output..
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
 |
 |