如果你的sname和gname没有什么要求的话的,可以用循环:begin
for i in 1..20 loop
insert into A(sno,gno,sname,gname) values(i,i,'jack'||i,'rose'||i);
end loop;
commit;
end;
for i in 1..20 loop
insert into A(sno,gno,sname,gname) values(i,i,'jack'||i,'rose'||i);
end loop;
commit;
end;
select 's' || to_char(level), 'g'|| to_char(level), 'sname'|| to_char(level),'gname'||to_char(level)
from dual
connect by level 10
select 's' || to_char(level), 'g'|| to_char(level), 'sname'|| to_char(level),'gname'||to_char(level)
from dual
connect by level<10
create sequence sequence_name
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 10;