Convert Static SQL to Dynamic SQL



SELECT NVL(COUNT(*), 0) st FROM ( SELECT * FROM dynamicsql PARTITION(dynamicsql_200012a) WHERE (number = '1101' OR number = '481101') UNION ALL SELECT * FROM dynamicsql PARTITION(dynamicsql_200012b) WHERE (number = '1101' OR number = '481101') );
FREE online converter from static SQL to dynamic SQL