Working with the code below how would one create a substitution variable that would allow me to
1. Pass a user entered variable with a prompt on runtime
2. Ask the Query to look for a specific group of tables say that start with 'A%' and only pick from the long list of tables that start with 'JAS.A'
3. Then I can enter a record to search for ' Insulation '
4. Will I have to show the whole list of 905 tables in the code so that Oracle know them or would I have to manually enter those myself showing only the tables starting with JAS.A%
5. Then of course after that run show the next variable to prompt for tables that start with 'B%' ..... then Search For Record ' Sub-Contractor' ....
6. Then next prompt "after the run of the last search".....'C%' Search Term 'Cleanup' ........so forth and so on.....
Am I thinking in the right frame of mind or way off...? The story of my life.
Select * From JAS.ACCOUNTS ;
Select * From JAS.ADDRESSES ;
/* and 901 other tables in between the line above and line below*/
Select * From JAS.WIP_EXPORT_DETAILS ;
Select * From JAS.WORK_ORDER_LABOUR_CODES ;
Select * From JAS.XLSX_TEXT ;
select table_name,column_name from (
'select count(*) X from ' || table_name || ' where to_char(' || column_name || ') = ''6328'' and rownum=1'
where owner ='JAS'
and table_name like 'JOB%'
order by table_name, column_name