As well as considering GoldenGate you could also use an Oracle Database Gateway.
Have a look here -
or if you have access to My Oracle Support review this note -
Master Note for Oracle Gateway Products (Doc ID 1083703.1)
You use the gateway in a database link to access the SQL*Server table and you can then use this in SQL statements.