Hey Gaz,

You can use Oracle Heterogeneous Services to allow ODBC based Database
Links to be created in the Oracle Server, after which you can query the
SQL Server tables via oracle and perform all standard ANSI sql
statements.

Cheers,

Shaun.