Toad World® Forums

Script that pulls data from a txt file in the where clause

I am trying to write an sql script in toad for oracle version 9.5 that when run will allow the user to select data from a txt file from the c drive where the parameters / variables are entered.

The version of oracle is 10g

e.g

select employee name from employees where employee-name in "C:\names.txt"