sqlplus:
BEGIN
FOR counter IN 1 .. 100
LOOP
insert into t1 values
( '2','2'||to_char(counter),null,null,null);
commit;
END LOOP;END;
BEGIN
FOR counter IN 1 .. 100
LOOP
insert into t1 values
( '2','2'||to_char(counter),null,null,null);
commit;
END LOOP;END;
a varchar2(20);
begin
for i in 1..100 loop
a:='2 '||to_char(i);
insert into table_name (hnmkcd,tjunno) values('2',a);
end loop;
end;
/