title: Oracle question: execute immediate
body: <p>I want to create table like this:</p>
  
  <pre><code>create table ttt
  (
     col1 varchar2(2),
     col2 varchar2(2),
     col3 varchar2(2),
     col4 varchar2(2),
     col5 varchar2(2)
  );
  </code></pre>
  
  <p>with this procedure, but it does not work.  May you help me?</p>
  
  <pre><code>declare
    str varchar2(200);
    i int;
  begin
    for i in 1 .. 5 loop
    begin
      str:=’str’||i||”;
    end;
    end loop;
    execute immediate ‘create table t1 (“str” varchar2(2) )’;
  end;
  /
  </code></pre>
  
  <p>Thanks in advance.</p>