oracleÅúÁ¿²åÈëÊý¾Ý

CREATE TABLE tempTable(id integer, name varchar2(30));
INSERT INTO tempTable VALUES (1, 'Hammer');

DECLARE counter integer:=1;
begin
while counter <=17
loop
INSERT INTO tempTable (id, name)
(SELECT id + (SELECT COUNT(*) FROM tempTable), 'Hammer' FROM tempTable) ;
counter:=counter + 1;
end loop;
end;
SELECT count(*) FROM tempTable;
drop table tempTable;