CONNECT BY LEVEL <=10

SELECT LEVEL  ID,'apple' NAME , 'red'   color,  1       quantity FROM dual CONNECT BY LEVEL <=10


ID NAME  COL   QUANTITY
-- ----- --- ----------
 1 apple red          1
 2 apple red          1
 3 apple red          1
 4 apple red          1
 5 apple red          1
 6 apple red          1
 7 apple red          1
 8 apple red          1
 9 apple red          1
10 apple red          1