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