创建一张测试表
CREATE TABLE TEST0322 (ID INT ,NAME VARCHAR2(20));
循环插入数据
BEGIN
FOR I IN 1..10000
LOOP
INSERT INTO TEST0322(ID,NAME)VALUES(I,'Henry'||i);
END LOOP;
COMMIT;
创建一张测试表
CREATE TABLE TEST0322 (ID INT ,NAME VARCHAR2(20));
循环插入数据
BEGIN
FOR I IN 1..10000
LOOP
INSERT INTO TEST0322(ID,NAME)VALUES(I,'Henry'||i);
END LOOP;
COMMIT;