|
SQL> with t as (select level n from dual where mod(level,3)=0 connect by level<= power(3,10)),
2 s(n,lvl) as ( select n,1 from t
3 union all
4 select t.n,s.lvl + 1
5 from s,t
6 where mod(t.n,power(3,s.lvl+1)) = 0
7 and s.lvl < 10
8 and s.n = t.n
9 )
10 select count(*) from s
11 /
COUNT(*)
----------
29524
|
|