Run Query Across Oracle and Postgres
This is what foreign data wrappers are for. 

There is one FDW for Oracle: https://laurenz.github.io/oracle_fdw/

A complete(?) list of available FDWs can be found in the Postgres Wiki: https://wiki.postgresql.org/wiki/FDW

See also CREATE FOREIGN TABLE