--根据某数据的要求不同,伪造不同条数的数据;
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
--根据某数据的要求不同,伪造不同条数的数据;
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