Convert Dynamic SQL to Static SQL
SQL Tuning
Convert Dynamic SQL to Static SQL
SQL Query
' SELECT NVL(COUNT(*), 0) st '|| ' FROM ( SELECT * '|| ' FROM dynamicsql PARTITION(dynamicsql_'||TO_CHAR(ADD_MONTHS(SYSDATE,-1), 'yyyymm')||'a)'|| ' WHERE (number = ''1101'' '|| ' OR number = ''481101'') '|| ' UNION ALL'|| ' SELECT * '|| ' FROM dynamicsql PARTITION(dynamicsql_'||TO_CHAR(ADD_MONTHS(SYSDATE,-1), 'yyyymm')||'b)'|| ' WHERE (number = :p1 '|| ' OR number = :p2) '|| ' )';
Help
Dynamic SQL to Static SQL
FREE online converter from dynamic SQL to static SQL
Dynamic SQL to Static SQL
×
Dynamic SQL to Static SQL Tool
1. Insert a SQL query
2. Click on a Dynamic SQL to Static SQL button
Dynamic SQL to Static SQL
×
Insert a SQL statement in SQL Query text area!