| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Spool Question
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 DBAReceived on Tue Dec 12 2006 - 01:39:06 CST
![]() |
![]() |