sqlplus select header question

From: John W. Hamill 265-3624 <johnh_at_gmcid.vssm.gmeds.com>
Date: 1996/09/04
Message-ID: <50kr6b$1ln_at_jupiter.cps.plnin.gmeds.com>#1/1


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 Wed Sep 04 1996 - 00:00:00 CEST

Original text of this message