There are many ways of doing that.
  • You can link an oracle server/db in the SQL Server then do a select from the linked server and insert into sql server table(s).
  • You can import the data using sql server management studio
  • Or you can just write your own code to do it.