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

Convert Static SQL To Dynamic SQL
1. Insert a SQL query
2. Click on Static SQL to Dynamic SQL button

Insert a SQL statement in text area!