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
Couch ModePrint It
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;
Click Here For Smileys :D
:D
:)
:[
;)
:D
:O
(6)
(A)
:'(
:|
:o)
8)
(K)
(M)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment