How to read the keys from a text file and select data from the database using them?

Question

Oracle

There is a CSV file containing the keys of the records from the Oracle database. (~5000 values).
You need to select all rows by the corresponding key from this file. How can this be done with a minimum number of routine operations (not to manually score all these keys)?

Answer 1

Create a table, load data from csv into it, and select it. What is the problem? Upload csv to oracle, well, this is a trivial task, the easiest way is through Sqldeveloper with the help of a mouse click, you can use sqlloader, you can connect this file as an external table.