insert into TMONTH_DATA(id, name, bir) select rownum as id, dbms_random.string('x', 10) || '大方扣扣的妈妈网' || dbms_random.string('x', 10) random_string, (TO_DATE('1991-01-01', 'YYYY-MM-DD') + DBMS_RANDOM.VALUE(0, SYSDATE - TO_DATE('1991-01-01', 'YYYY-MM-DD'))) from dual connect by level <= 10000000;
DM达梦数据库快速生成1000w数据
最新推荐文章于 2024-09-08 20:23:27 发布