How to build a query that gets its values from a file


I'm trying to build a query that uses the values in a file

select Epm,Emp_num,Emp_Addr From Dir_Rimco_Table where Emp in (Dir_Emp_Rsed.txt)


-I can't create a new table

-I can't modify Dir_Rimco_Table

-Current Privileges

enter image description here

Any idea how I can do that?

Best Answer

If the restriction on creating tables includes "external tables", then you need to get management to lift that restriction. As stated, you can't expect oracle (or any rdbms product, for that matter) to just magically be able to recognize some external file as a data source and be able to process it with SQL statements. External tables is how oracle does that. If you read up on external tables in the oracle docs, you will see that it is not a table that contains data within the database, but simply a description of an external file, and that allows oracle to treat that file as if it were an actual table.