oracle is my passion,to Work in a oracle database is a great fascination for me.I am at learning stage,lots of things remained to learn that's why I am here,I am working as a Researcher in KING SAUD UNIVERSITY, Riyadh.
SQL>begin for i in 1..1000000 insert into values (i,dbms_random.string('U',4),dbms_random.value(1,1000)); if mod(i,10000)=0 then commit; end if; end loop; end; /
This procedure is to help you to insert n number of record with random values.
No comments:
Post a Comment