October 2, 2003 at 2:29 pm
Hi,
I know there is Spool/Spool off feature in Oracle but I am not quite sure whether we have that kind of feature in SQL also. Help would be appreciated. Thanks
- Dhiren
October 2, 2003 at 5:38 pm
Not being an Oracle dude - what does it do?
Andy
October 6, 2003 at 1:04 pm
oh !!! I meant to say, Spooling feature in SQLPlus. Thanks
October 7, 2003 at 4:12 am
I still don't know what it does.
Andy
October 7, 2003 at 1:21 pm
What it does is, it stores data to the specified file location. I have been told that this spooling feature is in MYSQL also. Thanks.
October 8, 2003 at 3:44 am
Nope. You can redirect output from osql.exe to a file fairly easily. In SQL you'd typically use DTS to execute the query and export it to disk in whatever format you need.
Andy
October 20, 2003 at 11:03 pm
You can achieve the same.. through generating sql script or saving the script in .sql file.. fairly easy ..
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply