Every quarter we have to export to .txt file the same sub-tables from specific tables, like so:
(I'm very new to SQL and Toad, and I have no idea the correct terminology)
select * from MAIN_TABLE.THIS_OTHER_TABLE where RANDOM_COLUMN = 'random'
The only thing that changes is
MAIN_TABLE, which every quarter has a different sequential number. The rest of the code is the same.
What I want to do is for
MAIN_TABLE to be a variable, and not hardcoded, and that I can just change 1 variable in the Automation Designer and it would update all the other queries that I have.
The reason for this is that I need to export another 4 tables that have the exact same query every quarter, with just