--不用connect by，只用dual表，构造出1到128with a as (select 1 from dual union all select 1 from dual)select rownum from a, a, a, a, a, a, a;--做一个5*5的乘法表with multiplier as (select rownum n from dual connect by rownum<6)select a.n||‘*‘||b.n||‘=‘||(a.n*b.n) from multiplier a, multiplier b;
原文：http://www.cnblogs.com/mahun/p/4126138.html