Oracle spool output to file

Computing.Net > Forums > Database > Oracle spool output to file

Oracle spool output to file

Original Message

Name: anilcgowda
Date: May 10, 2006 at 13:03:33 Pacific
Subject: Oracle spool output to file
OS: Unix
CPU/Ram: 1GB

Comment:

Hi,
I'm trying to spool the output of my query in SQL Plus in Oracle to an output file. But, it includes column names before each row. Is there a way to spool the output to a file without column names included.
I'm using following set of commands:
SQL> Spool on
SQL> Spool c:\spooltext.txt
SQL> Query
SQL> Spool off
Please guide me as to what steps needs to be executed to avoid column headers.
Thanks,
Anil

Report Offensive Message For Removal

Response Number 1

Name: lchi2000g
Date: June 1, 2006 at 11:00:40 Pacific

Reply: (edit)

SQL> Spool on
SQL> set heading off <===
SQL> Spool c:\spooltext.txt
SQL> Query
SQL> Spool off
Luke Chi

Report Offensive Follow Up For Removal


SQL+ how to spool with data padding Unload data from table to file write into text file using spool help with ACT! 2006 to get package name from ora sys ta	PHP / MySQL Retrieve one record Ideas, please Spool File Using sqlldr to insert blob? write file to local hard drive

ACT! 2000 randomly runnin...

Convert Excel to Access d...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Oracle spool output to file

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 4 Days.
Discuss in The Lounge

PCMCIA card Microtech mp60287?

My PC got something wrong

Default Browser ?

Creative DXR2 DVD decoder

Installing Pastel on Vista

All Posts Awaiting Replies