title: oracle sql dynamic insert statement
body: <p>I have an oracle function that has a parameter which defines in which column the value should be inserted, e.g.</p>
  
  <pre><code> function something(p_value, p_nr) 
   is 
     ...
   begin
     if p_nr = 1 then
         insert into A (column1) (p_value);
     else if p_nr = 2 then
         insert into A (column2) (p_value);
     ...
     end if; 
  </code></pre>
  
  <p>I have a couple of values to enter in the table and only this value should be inserted dynamically. Is there an easier way to do this?</p>