title: how to add a column in a table with a name that is stored in a temporary variable
body: <p>I want to add a column in a table every time the loop is run. I created a temporary variable which would take a different name for each iteration in the loop. now I want to add a column in my table with same name. I tried something like this, part of code is shown in oracle sql developer:</p>
  
  <pre><code>DECLARE V_COUNT VARCHAR (10) := ZIP_COD
  BEGIN
  ALTER TABLE ABCD 
  ADD V_COUNT varchar(10);
  
  update ABCD b
  set b.V_COUNT = (select d.ZIP_cod
  from ORA_DMSTORE d
  where b.id_dmstore = d.id_dmstore);
  END;
  </code></pre>
  
  <p>this is showing the error " Usually a PL/SQL compilation error."
  i don't know how to get rid of it. please help</p>