with t as (select level+1000-1 i from dual connect by level<=400)select t.i ty1,t1.i ty2,t2.i ty3 from t,t t1,t t2 where t.i<1100 and t1.i<1200); Execute successful. Use time:253406 ms.