Hi guys,
It is possible to iterate some how in one select command?
Example:
I have one dates table: date_table
and select a_data from date_table.
I want to build a new select that will execute my date_table select for a specific number of times. I will input the number of times, using a parameter:
the resulting select will be similar to:
for i in 1..:n loop
select a_data + from date_table;
end loop;
Can I do this in one select?
joining with
(select a from (select level a from dual connect by 1 = 1) where rownum < 3) a
will be an idea?
Thanks