What is the easiest way to do a mass export of 300 tables in a schema with an in list. The in list is set as a variable in the beginning of the automation script. There are 2 clients with the same table names in each.
Example of export I need for 300 different tables:
SELECT * FROM client1.table1 WHERE LOAN_NUMBER IN (&VARIABLE)
SELECT * FROM client2.table1 WHERE LOAN_NUMBER IN (&VARIABLE)
Is creating 300 different exports the only way this is possible?
The exports need to go to .txt files that are named the same as the table.
Thank you for any assistance/guidance. I do not look forward to doing this manually 300 times. The initial build will be a time consuming monotonous bore.