November 18, 2008
This is an answer to Troels Arvin comment to my earlier post comparing different hierarchical methods.
The predicate limiting the size of the Integers relation would fit more naturally to the outer query block:
with integers(num) as (
select 1 num from dual
select num+1 from integers
) select * from integers where num < 10 ;
Pushing predicate inside recursive query definition doesn’t work, however (same as in competitor products).