Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Oracle spool output to file
Name: anilcgowda Date: May 10, 2006 at 13:03:33 Pacific 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.
Summary: A spool was typically a device to buffer output until it could be printed. Therefore normally it would hold the formatted output of the report. It seems what you want to do is spool the data file to...
Summary: Hi, Is it possible to download the contents of a table into a flatfile from Oracle DB, without headings and with delimiters lmiting the column values. Ex: the file contents should be like column1|colu...
Summary: hi.. i am using spool command to write data into text file returned by select statement. like spool Filename.TXT select ... select ... spool off can i use if condition between spool and spool off to c...
0 
