I want to simultaneously connect to two databases in python for a query that depends on the two databases in oracle sql developer
The example is following :
SELECT t1.id_client, t1.sales, t2.cost
FROM table_1@database_1 t1
JOIN table_2@database_2 t2
ON t1.id_client = t2.id_client
table 1 is from database_1
table 2 is from database_2
thanks!
I tried using cx_Oracle in python but it didnt work, it only connects to one of the databases.
New contributor
ignacio tz is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.