直接来语句,
BEGIN
for i in 1 .. 100
loop
insert into USERS (KEY,USERNAME,PASSWORD,EMILE,GRADE) VALUES (i,'zengjia','zeng123456','1609947354',99);
end loop;
commit;
end;
其中,USERS是表名;
(KEY,USERNAME,PASSWORD,EMILE,GRADE)是表中的列;
i,'zengjia','zeng123456','1609947354',99)是要插入的数值;