Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Spool Question

Re: Spool Question

From: sybrandb <sybrandb_at_gmail.com>
Date: 11 Dec 2006 23:39:06 -0800
Message-ID: <1165909146.695358.38310@l12g2000cwl.googlegroups.com>

CriticalJ_at_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
Received on Tue Dec 12 2006 - 01:39:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US