title: How to insert dynamically through a variable in PL/SQL?
body: <p>Lets create a table first</p>
  
  <pre><code>create table test
  (
    id number,
    name varchar2(20)
  );
  </code></pre>
  
  <p>Now during insert, I want to hold the data into variable first &amp; then dynamically pass the variable into the VALUES clause like this: </p>
  
  <pre><code>declare
    v_data varchar2(50);
  begin
    v_data:='1,sunny';
    execute immediate 'insert into test values(v_data)';
    commit;
  end;
  </code></pre>
  
  <p>But its showing some errors(Not enough values)...... plz help how to achieve this??</p>