title: Oracle Structure for loop column of table
body: <p>At work, they developed a code, where they declare one table with a %ROWTYPE (that table have 243 columns), and for every column they inserted a value.</p>
  <p>MYTABLE</p>
  <pre><code>COL_001 VARCHAR2(4000)
  COL_002 VARCHAR2(4000)
  ..
  COL_243 VARCHAR2(4000)
  </code></pre>
  <p>as you can see they are all VARCHAR2. this table was created because the data are readed from a csv file and then are inserted on that table.</p>
  <p>code:</p>
  <pre><code>CREATE OR REPLACE PROCEUDRE AS TEST
  v_rec MYTABLE%ROW_TYPE;
  
  BEGIN
    v_rec.COL001 := value;
    v_rec.COL002 := value;
    ...
    v_rec.COL243 := value;
  END TEST;
  </code></pre>
  <p>is it possible with other data structures to create a loop?</p>
  <pre><code>CREATE OR REPLACE PROCEUDRE AS TEST
  v_rec MYTABLE%ROW_TYPE;
  
  BEGIN
    for i in 1..243 loop
       v_rec.i:= value;
    end loop;
  END TEST;
  </code></pre>