Oracle: Select on data from a CSV file
You can do this using an Oracle External Table.

First, create a directory pointing at the directory holding the .csv file:

CREATE OR REPLACE DIRECTORY MYDIRECTORY AS '/path/to/yourdirectory';


Grant read access to your user:

GRANT READ ON DIRECTORY MYDIRECTORY TO YOURUSER;


Create a table that'll read from your CSV file:

CREATE TABLE mytable
(
  id NUMBER
)
ORGANIZATION EXTERNAL
  (
    TYPE ORACLE_LOADER
    DEFAULT DIRECTORY MYDIRECTORY 
    ACCESS PARAMETERS
      (RECORDS DELIMITED BY NEWLINE
        FIELDS (id NUMBER)
      )
    LOCATION ('yourfile.csv')
 );


Your query would then be:

SELECT * FROM TABLE WHERE ID IN (SELECT id FROM MYTABLE);