how to get records from a file to use those records in a select statement?

Question

Hi i have a file that consists of ids.

my statement is

select * from table_name where id in (?)

? in the statement should have ids.....but those ids are in file.

help me please what i have to write in the place of ? symbol

without creating table in database cant we done above thing?

Thanks in advance

Answer 1

You should import the file into the database.

You can use SQL*Loader for that, or create a table with ORGANIZATION EXTERNAL

Answer 2

You could compose the SQL query as a string in the (PHP/C#/Java/other) code that uses the database. I'd really think that either keeping the IDs in the database or importing the file would be the easiest way, if there isn't something about your constraints that prevents it.