Re: avoiding column heading in extracted data

On 14 Aug, 10:36, 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
> 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

http://download.oracle.com/docs/cd/B19306_01/server.102/b14356/toc.htm

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