Convert Static SQL to Dynamic SQL

SQL Tuning
Convert Static SQL to Dynamic SQL

SQL Query

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

Static SQL to Dynamic SQL

Static SQL to Dynamic SQL Tool

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

Static SQL to Dynamic SQL

Insert a SQL statement in SQL Query text area!