BEGIN
FOR i IN 100000..300000 LOOP
insert into table_name (column1,2,....)
values(2013,234,i,5951,'01-JAN-2013',20.2,0,20.2,'31-DEC-2013') ;
COMMIT ;
END LOOP;
END;
Monday, May 19, 2014
Store procedure to simulate dummy data
BEGIN
FOR i IN 100000..300000 LOOP
insert into table_name (column1,2,....)
values(2013,234,i,5951,'01-JAN-2013',20.2,0,20.2,'31-DEC-2013') ;
COMMIT ;
END LOOP;
END;
Subscribe to:
Posts (Atom)