摘要：
create table myTestTable asselect rownum as id,to_char(sysdate + rownum/24/3600, 'yyyy-mm-dd hh24:mi:ss') as inc_datetime,trunc(dbms_random.value(0, 100)) as random_id,dbms_random.string('x', 20) random_stringfrom dualconnect by level <= 100000;上面SQL是利用了Oracle数据库语法的几个实用小技巧实现的：1、利用 阅读全文
