If you are going to run the query from the Oracle database, you would need to use Heterogeneous Services and create a database link to the Sql server database.
Then you can access Sql Server’s tables by suffixing them with ‘@<database_link_name>’
If you are going to do it from Sql Server, you will need a linked server.
Have a look at these links:
REGISTER or login: