Re: sqlplus select header question

You can set pagesize 0 to suppress all headers, etc., and then put in the headers you want (once) by selecting some literals from dual (for instance).

johnh_at_gmcid.vssm.gmeds.com (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!!
Received on Fri Sep 06 1996 - 00:00:00 CEST