How to insert into the database, 100000 data records, data no repeat?

CodePudding user response:

The select dbms_random. String (' s', 10) from dual connect by rownum & lt;=10

CodePudding user response:

Random also has a chance to repeat, it is ok to use rownum directly the select rownum from dual connect by rownum & lt;=100000

CodePudding user response:

Don't know what your table structure, but is basically can use INSERT INTO table_name SELECT... The from dual;
Use field should have the select sys_guid (), the rowid, rownum, sysdate from dual;