Oracle sql : read/write to CSV files using sql

Question

By using SQL, I need to read data from a CSV file that contains rows of 3 values and then use it in a WHERE clause in a SELECT statement, after that dump the results of the SELECT (7 fields in total) in a new CSV file.

The query looks like :

SELECT
    COL_1,
    COL_2,
    COL_3,
    COL_4
    ...
FROM
    MyTable
WHERE
    COL_1 = *INFO_FROM_CSV*
    COL_2 = *INFO_FROM_CSV*
    ...

I am using now UTL_FILE to read the data and store it in a new table, then using SPOOL to export it, is there a better way to do it?