--不用connect by，只用dual表，构造出1到128
with 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;