title: execute immediate create table and update table
body: <p>I am creating a temp table in pl/sql using execute immediate &amp; also inserting in the table why create table.</p>
  
  <p>After that I m updating the table. But i m getting error table doesn't exists as it is not creating the table thr execute immediate </p>
  
  <p>sample code---------</p>
  
  <pre><code>begin
    execute immediate 'create table t23 as  select ''1'' aa from dual'; 
    update t23 set aa ='2' where aa='1';
    COMMIT ;
  end;
  </code></pre>