Question: how to import data from oracle database to sql server?
Answer: Use a tool such as Microsoft SQL Server Migration Assistant for Oracle.
Use SQL Server Integration Services (SSIS)
Create a Linked Server on SQL Server pointing to the Oracle database.
Export Oracle data to a CSV file and then import the data to SQL Server via bulk copy.