Re: avoiding column heading in extracted data

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

On 14 Aug, 10:36, n <> wrote:
> hi
> i am new to sql. i am using sql plus to extract data from oracle. i am
> 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

HTH -g Received on Thu Aug 14 2008 - 05:02:56 CDT

Original text of this message