SELECT 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_STRING FROM DUAL CONNECT BY LEVEL <= 10; SELECT '('||WMSYS.WM_CONCAT(':P' || ROWNUM)||')' V_SQL FROM DUAL CONNECT BY LEVEL <=4;