Re: avoiding column heading in extracted data

From: rajeev <>
Date: Thu, 14 Aug 2008 02:56:57 -0700 (PDT)
Message-ID: <>

On Aug 14, 5:36 am, n <> wrote:
> hi
> i am new to sql. i am using sql plus to extract data from oracle. i am
"set pages 0" from sqlplus, before running your query
> spooling the data to a .txt file but the volume of the data is more
> than 8GB and notepad cant open the file.
> ultimately i have to import the data into sas and analyse it.
> however, in the extracted data, the column headings are repeated after
> either each row or a group of rows.
> i would like to have the data serially without the headings in between
> so that it can be used in sas easily.
> plz suggest how this can be done.
> thanks and regards
Received on Thu Aug 14 2008 - 04:56:57 CDT

Original text of this message