Question: can ssms connect to oracle database?
Answer: Select The Oracle driver (may vary depending on Oracle client version) and click Finish. Open Microsoft Sql Server Management Studio. On the menu on the left expand “Server Objects” and right click on Linked Servers. Select New Linked Server… from the popup menu.