Why should we use oledb?

Question

We have separate data providers for Oracle, SQLServer.
Say we are working on Oracle. Tomorrow, we might have to migrate it to Sqlserver. Should we use OLeDB then?
I am confused when should we use oledb, sqlclient,oracleclient, ODBC etc. Please guide.