Returning same row n amount of times.

[slimdave]

I wonder if it might be better expressed as ...

select empname
from emp, 
(select 1 from all_objects where rownum <= 15) num_list
where empid = 123
/

It would translate more easily to different predicates like "emp_id in (1,2,3)" etc then as well.

I usually like to have a nice big table of integers for this kind of thing ... there's generally a lot of uses for it, and it takes up very little space.