Re: sqlplus select header question

John W. Hamill 265-3624 wrote:
>
> Does anyone know how to do a select and have only one header print instead of
> having a header on each page of output.
>
> When I do a select I get an output that looks like this:
>
> field1 field2 ...
> data data data
> data data data
> data data data
> data data data
> data data data
> field1 field2 ...
> data data data
> data data data
> data data data
> data data data
> data data data
>
> I want this
> field1 field2 ...
> data data data
> data data data
> data data data
> data data data
> data data data
> data data data
> data data data
> data data data
> data data data
> data data data
> --
> John W. Hamill, EDS `""""""" PROFS: SMTP(JHAMIL01) Voice:(810)528-6139
> Mail Drop 28 (. (. > lnussat.jhamill_at_eds.com Fax :(810)528-6408
> 1450 Stephenson Hwy R1100RS 94BMW There is a $50.00 charge for any junk sent
> Troy, MI 48083 KZ440D2 LTD 81Kaw to me. The above are my views only!!

I THINK you need to set you pagesize to zero and then the header should only print once.

Iceberg. Received on Thu Sep 05 1996 - 00:00:00 CEST