WITH t AS(
SELECT 'a' id FROM dual UNION ALL
SELECT 'b' FROM dual
)
SELECT DISTINCT level,t.* FROM t CONNECT BY LEVEL<=2;
WITH t AS(
SELECT 'a' id FROM dual UNION ALL
SELECT 'b' FROM dual
)
SELECT DISTINCT level,t.* FROM t CONNECT BY LEVEL<=2;