avoiding column heading in extracted data

From: n <nikhil.abhyankar_at_gmail.com>
Date: Thu, 14 Aug 2008 02:36:24 -0700 (PDT)
Message-ID: <c40593ea-a8fb-4505-af61-2e96a4fcdd00@z72g2000hsb.googlegroups.com>


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 Received on Thu Aug 14 2008 - 04:36:24 CDT

Original text of this message