伪造数据

--根据某数据的要求不同，伪造不同条数的数据；

with t as (

select 3 id, 'a' val from dual union all

select 4 id, 'b' val from dual )

SELECT lv, val

  FROM t, (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 10)

WHERE id >= lv

ORDER BY val, lv