Need to run many SQL's at one shot even if error occurs inbetween
I need help in executing SQL's. I have some say 50 SQL's combined using UNION ALL. Now when we ran the SQL's at one shot, it stops when it found error like "Column/table does not exist for few SQL" and does not execute any SQL's.
I want the SQL to execute completeley and skip those SQL's where we have errors.