CREATE TABLE myTable
AS
SELECT ROWNUM id,
to_char(sysdate+ROWNUM/24/3600,'yyyy-mm-dd hh24:mi:ss') inc_datetime,
trunc(dbms_random.value(0,100)) random_id,
dbms_random.string('x',20) random_string
FROM dual
CONNECT BY LEVEL <=100000;
阅读(1072) | 评论(0) | 转发(0) |
