IIRC there is a SPOOL command that will redirect the ouput of a SELECT
statement to a file. It should be fairly easy to import that to MSSQL
using DTS or BCP. However, there are probably several ways of doing
this and I'm not an Oracle expert so for better advice you may want to
repost in an Oracle group.

--
David Portas
SQL Server MVP
--