How about a cartesian product with a big enough table and limit with rownum:
select empname
from emp, all_objects
where empid = 123
and rownum <= 15;
(I'm sure Tamil will show us how to do this with CUBE!)
|
Results 1 to 10 of 12
Threaded View
|
Click Here to Expand Forum to Full Width |