17,082
社区成员
发帖
与我相关
我的任务
分享
with t1 as (select level as lv1 from dual connect by level <1001), --这里是构造了1--1000的数据列
t2 as (select chr(lv) as lv2
from (select level as lv
from dual
connect by level < 123
minus
select level as lv from dual connect by level < 97)
) --这里是构造了 a--z的数据集合
select t.*
from table1 t
inner join t1 on t.field1 = t1.lv1
inner join t2 on t.field2 = t2.lv2 --通过关联 得出结果集