Oracle Database Discussions

i need to capture certain fields from certain tables in database 1 and certain fields from certain tables in database 2 into one file using a single SQL statement.

i tried searching on the net
where i found that dblinks can help
but iam not sure if ill be able to create dblinks in my situation which is:

i need to get data from oracle to be copied to mysql
this is not a replication acitivity, but i need certain fields from one database and certain from the other

so what iwas thinking is, if i use an sql query to get all the fields i need (around 40) from the different oracle databases and create a singlefile with one insert per select, i can then read that file into mysql
instead of creating multiple sql queries for each table and creating separate files and eventually separate tables in mysql.

can anyone help me here?
or maybe suggest another approach.

thanks