oracle造数据测试

oracle–建表

create table DXP_QGM_TEST_THREE
(
ID NUMBER(4) PRIMARY KEY,
DOM_DATETIME VARCHAR(255),
DOM_ID NUMBER(10),DOM_STRING VARCHAR2(255)
);

–造数据
insert into DXP_QGM_TEST_THREE
(ID, DOM_DATETIME,DOM_ID,DOM_STRING)
select rownum as ID,
to_char(sysdate + rownum / 24 / 3600, ‘yyyy-mm-dd hh24:mi:ss’) as DOM_DATETIME,
trunc(dbms_random.value(0, 100)) as DOM_ID, dbms_random.string(‘x’, 20) DOM_STRING
from dual connect by level <= 1000;