Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mis_techlady
Starting Member
3 Posts |
 Posted - 2004-08-18 : 10:49:41
|
| Hi!How do I add the text 'END-OF-FILE' to the end of a text file that is created by spool?Example:spool /directory/text_file.txt;select ...;spool off;exit;Thanks-for-your-help,mis_techlady |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-08-18 : 11:14:02
|
| Can you elaborate on what spool is?What language are you using and how exactly are you creating the text file? |
 |
|
|
mis_techlady
Starting Member
3 Posts |
Posted - 2004-08-18 : 12:14:27
|
| Spool is an Oracle SQL PLUS command that allows you to create text files as output files.I see that the spool command, in Oracle 10g, now has the option of append (to append to the given spool file). That is a good enhancement, but I am not using Oracle 10g.mis_techlady |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-08-18 : 14:08:04
|
| You may recieve a quicker response to this question at dbforums.com as this is primarily a SQL Server forum. |
|
|
|
mis_techlady
Starting Member
3 Posts |
Posted - 2004-08-18 : 15:23:13
|
| I have my answer.mis_techlady |
|
|
|
|
|
|
adding text to a text file created by spool