Convert Dynamic SQL to Static SQL



' 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
FREE online converter from dynamic SQL to static SQL

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

Insert a SQL statement in text area!