今天上午用程序生成的一个SQL，同事建议不要过多设置条件，全部取出然后在内存中处理。我不以为然，反正是程序生成的，就写了下去。
没想到生成的SQL居然有1524行，结果当然是被吐槽了，可读性太差了。我的名字被标注那里，大家说是以后谁复查到这里就来找我麻烦。
目前任务紧，没有时间重写了，以后再换种方式实现吧。但还是要纪念一下，因为...实在是太长太长了...
看这里：
select A0.bb,
A1.bb,
A2.bb,
A3.bb,
A4.bb,
A5.bb,
A6.bb,
A7.bb,
A8.bb,
A9.bb,
A10.bb,
A11.bb,
A12.bb,
A13.bb,
A14.bb,
A15.bb,
A16.bb,
A17.bb,
A18.bb,
A19.bb,
A20.bb,
A21.bb,
A22.bb,
A23.bb,
A24.bb
from ((select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 20:51:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A0 left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 20:56:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A1 on
A0.aa = A1.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:01:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A2 on
A1.aa = A2.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:06:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A3 on
A2.aa = A3.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:11:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A4 on
A3.aa = A4.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:16:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A5 on
A4.aa = A5.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:21:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A6 on
A5.aa = A6.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:26:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A7 on
A6.aa = A7.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:31:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A8 on
A7.aa = A8.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:36:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A9 on
A8.aa = A9.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:41:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A10 on
A9.aa = A10.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:46:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A11 on
A10.aa = A11.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:51:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A12 on
A11.aa = A12.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 21:56:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A13 on
A12.aa = A13.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:01:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A14 on
A13.aa = A14.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:06:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A15 on
A14.aa = A15.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:11:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A16 on
A15.aa = A16.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:16:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A17 on
A16.aa = A17.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:21:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A18 on
A17.aa = A18.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:26:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A19 on
A18.aa = A19.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:31:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A20 on
A19.aa = A20.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:36:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A21 on
A20.aa = A21.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:41:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A22 on
A21.aa = A22.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:46:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A23 on
A22.aa = A23.aa left join
(select count(distinct po.session_id) as bb, 1 as aa
from (select t.*
from pub_online t
where t.login_time < '20130321 22:51:44') po
inner join((select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000368'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000369'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000370'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000372'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000371'
CONNECT BY PRIOR organ_id = parent_id)
union (select stru.stru_type,
stru.stru_level,
stru_id,
organ_id,
parent_id,
organ_alias
from pub_stru stru
START WITH stru_id = 'S00000000000373'
CONNECT BY PRIOR organ_id = parent_id)) A on po.corporation_id =
A.STRU_ID) A24 on
A23.aa = A24.aa)
相关推荐
html5微信小游戏源码 奇葩连连看游戏源码（仅用于参考）html5微信小游戏源码 奇葩连连看游戏源码（仅用于参考）html5微信小游戏源码 奇葩连连看游戏源码（仅用于参考）html5微信小游戏源码 奇葩连连看游戏源码（仅...
所见过的13种最为奇葩的编程语言,无聊之余的谈资. 不喜勿喷
奇葩过最新安全狗拿SHELL奇葩过最新安全狗拿SHELL奇葩过最新安全狗拿SHELL奇葩过最新安全狗拿SHELL奇葩过最新安全狗拿SHELL奇葩过最新安全狗拿SHELL奇葩过最新安全狗拿SHELL奇葩过最新安全狗拿SHELL奇葩过最新安全狗...
《奇葩连连看HTML5游戏源码解析》 HTML5作为现代网页开发的主流技术，以其强大的功能和跨平台性赢得了开发者们的广泛喜爱。本篇将深入解析“奇葩连连看”这款基于HTML5的游戏源码，旨在帮助读者了解HTML5游戏开发的...
在处理JSON数据时，我们通常会遇到各种情况，包括标准的、规范的JSON格式以及一些“奇葩”的、非正式的JSON数据。这个话题“奇葩json数据解析”就聚焦于如何处理那些不符合标准的JSON数据。 在描述中提到，使用...
在这个奇葩版Flappy Bird中，JavaScript代码会控制小鸟的飞行、管道的生成与移动、分数计算以及游戏结束条件的判断。JavaScript中的事件监听器接收用户的点击或触屏动作，使小鸟上下飞行；同时，通过定时器来更新...
微信小游戏源码 奇葩连连看游戏源码（仅用于学习参考）微信小游戏源码 奇葩连连看游戏源码（仅用于学习参考）微信小游戏源码 奇葩连连看游戏源码（仅用于学习参考）微信小游戏源码 奇葩连连看游戏源码（仅用于学习...
奇葩工具箱2014.10.19最新版本 奇葩工具箱Beta5.0.8更新内容： 1.修复*启动程序后右上角显示不明标签问题； 2.调整*对奇葩闹钟功能做了一点调整； 3.取消*QQ个性网名,签名,头像,分组大全等QQ相册封面拼图； 4....
"奇葩工具箱Beta4.7.6"是一款集成了多种实用功能的软件工具箱，主要以QQ、贴吧和电脑应用为核心，旨在为用户提供便捷、全面的解决方案。从其名称可以看出，这款工具箱可能包含了一些非传统或者独特的工具，可能是...
《江南戏曲奇葩——越剧》教学设计2.pdf
12306奇葩验证码原理,讲述了生成的原理和验证的原理,12306奇葩验证码原理
《SQL 21日自学通(V1.0)》是一本针对初学者设计的自学教材，旨在帮助读者用21天的时间掌握SQL的基础知识和应用技能。SQL（Structured Query Language，结构化查询语言）是数据库领域中广泛使用的一种标准编程语言，...
《奇葩说》作为一档成功兼顾娱乐与深度的综艺节目，在娱乐产业中开创了一片新天地。自2014年首播以来，它不仅在形式和内容上进行了大胆的创新，而且始终紧贴时代的脉搏，洞悉了市场的需求，尤其是对年轻观众的心理...
钢琴音乐的奇葩.ppt
奇葩小组名称创意.doc
初中语文文摘励志奇葩大爷
描述中的“网络下载的城市数据零零散散的，各种奇葩的坑”可能是指数据在收集过程中可能存在不一致性、缺失值或错误，这在数据清洗和预处理阶段会成为挑战。"此 SQL 共 3740 条数据"则告诉我们数据库包含的具体记录...
解决开奇葩没放电影前卡
《2013万能淘宝奇葩会场辅助v2.5》是一款专为2013年双十二购物狂欢节设计的辅助工具，旨在帮助用户更高效、便捷地参与淘宝网上的各种促销活动。该软件集成了多项实用功能，旨在解决用户在淘宝奇葩会场购物时可能遇到...
安卓奇葩音乐播放器源码是个奇葩其实一点也不冤枉这个项目，整个播放器只有一个循环播放的动画画面，打开软件会自动扫描SD卡上的音乐并且把少于一分钟的音频过滤掉然后随机播放一个音乐。项目权当娱乐了，可以把动画...