quinta-feira, 6 de outubro de 2011

Select on table dual return any number row


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

select * from dual
connect  by 1 = case when rownum <=100 then  else 0 end ;