title: how to add column and fill it with value in oracle stored procedure
body: <p>I have a task on my studies that says to make a procedure that adds new column 'BRUTTO' to a table and fills it's records with values based on defined variable = 24 and values from column 'NETTO'. I wrote this but it doesn't work. Any help is appreciated.</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE WSTAW_KOLUMNE_BRUTTO  
  AS  
     CURSOR C IS   
       SELECT NETTO  
       FROM TABELA_1  
       FOR UPDATE
       ;
       V_VAT NUMBER(9,2) := 24;
  BEGIN
      EXECUTE IMMEDIATE 'ALTER TABLE TABELA_1 ADD BRUTTO NUMBER';
      FOR V_REKORD IN C
      LOOP
         EXECUTE IMMEDIATE 'UPDATE TABELA_1 SET BRUTTO = ' 
             || V_REKORD.NETTO * (1 + 24/100)||' WHERE CURRENT OF C';
      END LOOP;
  END WSTAW_KOLUMNE_BRUTTO;
  </code></pre>