Providing you have access permissions you can set up a LINKED SERVER in SQL Server, either using the Enterprise Manager GUI or by scripting. You can then access the data in Oracle and perform queries whereby you insert into a SQL table data from an oracle one. Alternatively, for a more transient connection, you can use OPENQUERY or OPENROWSET and pass a connection string in. Search for the capitalised terms in BOL.
Joe (Microsoft MVP - XML