Sunday, April 7, 2019

Creating a table and inserting 1 hundred thousand record

Creating a table and inserting 1 hundred thousand record


create table mqm1 (id varchar2(20));

begin
for i in 1..100000 loop
insert into mqm1 values(i);
end loop;
commit;
end;
/


No comments:

Post a Comment