Who ever stated that a select on the table "dual" returned a number of lines
different from 1, below is a solution that met in this case returns 100 lines
different from 1, below is a solution that met in this case returns 100 lines
select * from dual
connect by 1 = case when rownum <=100 then 1 else 0 end ;