declare aa integer :=1;begin while aa<10 loop insert into test values('test',aa); aa:=aa+1; end loop;end;