title: ORA-00926: missing VALUES keyword while using insert into table as select * from in execute immediate
body: <p>I have two table emp1 and emp2 i want to create emp3 by using emp1 and emp2 all this i need to do plsql to automate code </p>
  
  <p>I tried coding but getting</p>
  
  <blockquote>
    <p>ORA-00926: missing VALUES keyword ORA-06512: at line 9</p>
  </blockquote>
  
  <pre><code>declare
  v1  varchar2(2000);
  begin 
  for i in 1..2
  loop
  v1:='insert into emp3 as select * from emp'||i||'where 1=1;';
  execute immediate v1;
  end loop;
  end;
  </code></pre>
  
  <p>ORA-00926: missing VALUES keyword
  ORA-06512: at line 9.
  i have a bigger where condition but i just used 'where 1=1' and bigger tables but i need the logic for this thanks!</p>