title: EXECUTE IMMEDIATE in Oracle 12c?
body: <pre><code>begin
  execute immediate select ename, 
                           empno 
                    from  emp 
                    where ename !='James';
  end;
  /
  </code></pre>
  
  <p>getting </p>
  
  <blockquote>
    <p>ORA-00904: invalid identifier error while executing above code.</p>
  </blockquote>
  
  <p>And is that possible to have multiple execute immediate statements create table , drop table and create indexes also ?</p>