CREATE TABLE test_data
(
ID varchar2(32),
NAME1 varchar2(9),
NAME2 varchar2(100),
NAME3 varchar2(100)
);
COMMENT ON TABLE test_data IS '测试表';
begin
for i in 1 .. 1000000 loop
INSERT INTO "DCA"."TEST_DATA" ("ID", "NAME1", "NAME2", "NAME3")
VALUES ('id_' || i, i, 'nme2_' || i, 'name3_' || i);
end loop;
end;
/
SELECT * FROM test_data;
SELECT count(*) FROM test_data;