Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Quick sqlplus cr/lf question
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.orgReceived on Thu Aug 03 2006 - 16:56:18 CDT