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

Home -> Community -> Usenet -> c.d.o.server -> Re: Quick sqlplus cr/lf question

Re: Quick sqlplus cr/lf question

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 03 Aug 2006 14:56:18 -0700
Message-ID: <1154642178.989724@bubbleator.drizzle.com>


BD wrote:
> Hey, all.
>
> I'm making a gen script which will create a report file, which will
> then be mailed out.
>
> I am looking through 'show all' to find a setting I can turn off, which
> will remove the extra blank lines between my headings: I have a series
> of "select '<whatever'> from dual, which make up a little header
> paragraph for the report. But each of these is separated by a blank
> line in the output.
>
> The lines comprising the data itself are not separated by blank lines.
>
> I've tried all the standard feedback/echo/verify settings, and none
> have any effect on this.
>
> Anyone know?
>
> Minor annoyance, but it'd be nice to clean it up.
>
> Thanks!
>
> BD
>

set pagesize 0

And if that doesn't do it you need to better explain what you want.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Aug 03 2006 - 16:56:18 CDT

Original text of this message

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