oracle中造大数据量的测试数据

CREATE
    TABLE TEST_EXPORT NOLOGGING PARALLEL 4 AS
SELECT
    LEVEL           AS ID,
    LEVEL||'NAME'   AS NAME,
    LEVEL||'REMARK' AS REMARK
FROM
    DUAL CONNECT BY LEVEL<=300000;

 

 

 

直接可以运行，但是仅限于oracle