set linesize won't stop it from printing the headings every couple of
rows -- that has to do with the pagesize set
set pagesize to an extremely large number and you will get just the
one heading, as long as that number is higher than the number of rows
(including header) you will print
--- "De
Title: RE: formatting in SQLPLUS
Thanks,
I
set pages 999 and it works fine now.
Regards
$uhen
Or try.
set pagesize xxx
where xxx is the number of lines per page.
-Original Message-
From: Dennis M. Heisler [mailto:[EMAIL
[mailto:[EMAIL PROTECTED]]
> Sent: Monday, 4 February 2002 12:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: formatting in SQLPLUS
>
> set linesize = xxx
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dennis M. Heisl
Oops... that's pagesize, not linesize
"Dennis M. Heisler" wrote:
> set linesize = xxx
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dennis M. Heisler
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Dieg
Title: RE: formatting in SQLPLUS
Or try.
set pagesize xxx
where xxx is the number of lines per page.
-Original Message-
From: Dennis M. Heisler [mailto:[EMAIL PROTECTED]]
Sent: Monday, 4 February 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: formatting in
set linesize = xxx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
List,
I am creating a report via sqlplus.
I am working with the formatting. When I run the report it puts the headings
for the columns after every 2 rows of
the report. I would like to have the
headings at the top of the report
only.
I could set the heading off but it would