title: I am trying to insert multiple rows dynamically in SQL
body: <pre><code>create table ACCOUNTS
  (
       AccNo int, 
       CName char(25), 
       Balance int,
       Primary key(AccNo)
  );
  
  declare
      c char;
      b int;
  begin
      for i in 1 .. 3
      loop
          insert into accounts values ( i, 'AccNo',&amp;c,'Cname',&amp;b,'Balance' );
      end loop;
  end;
  </code></pre>