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 |
|
neha7.m
Starting Member
1 Post |
 Posted - 2009-12-11 : 00:40:27
|
| I need to know as to what "spool" in sql does. I've these statements in spool:spool <jodname>--queriesspool off |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2009-12-11 : 03:51:36
|
| Rather marvelously, Google will have told you that it's Oracle by the time you've typed "spool off" -- before you've even hit the enter key. |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-15 : 14:41:39
|
| spool [SQL*PLUS] SQL> spool name_of_fileSQL> spool name_of_file offSQL> spool name_of_file outSQL> spool name_of_file createSQL> spool name_of_file appendSQL> spool name_of_file replaceThe three modifiers create, replace and append are improvements that come with Oracle 10g.RAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Spool