Path: text.usenetserver.com!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!l12g2000cwl.googlegroups.com!not-for-mail
From: "sybrandb" <sybrandb@gmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Spool Question
Date: 11 Dec 2006 23:39:06 -0800
Organization: http://groups.google.com
Lines: 28
Message-ID: <1165909146.695358.38310@l12g2000cwl.googlegroups.com>
References: <1165853939.130361.125150@l12g2000cwl.googlegroups.com>
   <1165858003.371783.206380@79g2000cws.googlegroups.com>
   <1165868359.062729.148560@l12g2000cwl.googlegroups.com>
NNTP-Posting-Host: 89.200.19.45
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165909152 10123 127.0.0.1 (12 Dec 2006 07:39:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 07:39:12 +0000 (UTC)
In-Reply-To: <1165868359.062729.148560@l12g2000cwl.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: l12g2000cwl.googlegroups.com; posting-host=89.200.19.45;
   posting-account=d8kqXg0AAADvDUR8IdYEU7pAZnZ1O2PC
Xref: usenetserver.com comp.databases.oracle.misc:244836
X-Received-Date: Tue, 12 Dec 2006 02:39:12 EST (text.usenetserver.com)


CriticalJ@gmail.com wrote:
> Thank you for the reply.
>
> I tried your suggestions.
>
> At first I tried them in SQL Plus Worksheet.  No matter what
> combinations I used, I could not get it to work.
>
> Finally, I tried SQL Plus.  After experimenting for a while, I finally
> got the data to export to a text file.
>
> As a follow up question, is it possible to get column headers for this
> data?  Everytime I tried this, it failed miserably.  This seems like it
> should be easier than what I am making it.

It is easier when you read the sql*plus reference manual.
And obviously
set heading off
will suppress column headers, as that is the very purpose of the
command.
You wouldn't have complained if you would have verified this in the
manual.

-- 
Sybrand Bakker
Senior Oracle DBA