Returning same row n amount of times.

[tamilselvan]

Dapi will be disappointed if I do not give my script.

select A.*
from ( select id 
         from test_load 
        where id = 10 ) A, ---- this will return one row
     ( select 1 
         from dual 
        group by cube(1,1,1,1)) B
where rownum < 16
/ 

Tamil