There is not a very direct federation option as of now as far as I know. However bigquery supports external functions, this means you can create an external function and pass a query which "may" connect to an Oracle database and execute it. However I did not try it, I imagine connectivity from a cloud function to an Oracle database may require some network magic.