Re: avoiding column heading in extracted data

From: rajeev <rajeev.ramdas_at_gmail.com>
Date: Thu, 14 Aug 2008 02:56:57 -0700 (PDT)
Message-ID: <a2c87bec-fe9e-48b0-9340-01da17ef96a7@i76g2000hsf.googlegroups.com>


On Aug 14, 5:36 am, n <nikhil.abhyan..._at_gmail.com> 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