奇葩的SQL《谨纪念》

最新推荐文章于 2023-02-05 21:48:35 发布
最新推荐文章于 2023-02-05 21:48:35 发布
阅读量133 收藏
点赞数
文章标签： Oracle SQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/villaleeadi/article/details/84417363
版权

今天上午用程序生成的一个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)
villaleeadi
关注
关于SQL SERVER 的授权问题
weixin_43431189的博客
04-17 2202
关于SQL SERVER 的授权问题 转载自 a.正常的授权流程应该为 1、添加用户角色 要想成功访问 SQL Server 数据库中的数据， 我们需要两个方面的授权： 1.获得准许连接 SQL Server 服务器的权利；就像我们获取了进入某栋大楼的权利 2.获得访问特定数据库中数据的权利（select, update, delete, create table …）；就像我们拿到了大楼内某个房...
shell 里面的奇葩字符实现
09-14
以下是一些在Shell中常见的奇葩字符及其详细解释： 1. **分号** (`;`)：通常作为命令分隔符，允许你在一行内执行多个命令。尽管在编写脚本时，推荐每行只写一个命令以提高可读性。 2. **双分号** (`;;`)：在`case`...
Java岗大厂面试百日冲刺 - 日积月累，每日三题【Day18】—— 奇葩问题合集
陈哈哈的菜园子
07-01 9811
欢乐的奇葩问题合集，让我们一起送给这个愉快的周五，摸鱼之路就是这么坚实且平躺。对了，周末加班的兄弟们除外~
记一次奇葩的sql注入联合查询黑名单绕过与布尔盲注绕过
weixin_48421613的博客
10-27 4618
近日为甲方爸爸挖漏洞，又是遇到奇葩SQL注入的一天。 首先，页面是这个样子滴 注意两个蓝色的框 一个小单引号之后，报错了，好样的，sql注入无疑了 由于是Get型注入，所以一开始想直接用union联合查询 使用二分法得知，字段数量是9 2. 使用联合查询，这里被拦住了 代码君已私奔到月球，这是啥玩意？ 一开始以为是最常见的 union select 联合查询黑名单过滤，于是乎使用了大部分的方式都是对这两个单次进行绕过，什么大小写、双拼、编码转换，这里要说的是， /**/ 这种的也会被屏蔽 而后
什么工具能自动生成SQL 这么牛
Wis57的博客
02-05 3142
本以为这种 ‘必须要用一句 SQL’ 来实现 的奇葩定制化需求，不可能有轮子，但是看到这个用js编写的开源项目， 有着2.9K star 心里好受了些，毕竟有近3000个怨种和我一样被产品折磨，哈哈哈。需求受限于业务，由于业务非常复杂，且数据量极大，所以有了这个需要上千行SQL才能解决的业务。
SQL调用WebService接口
我们的征途是星辰大海
07-03 5847
今天在做一个很奇葩的东西，中间有个过程要在SQL触发器里面调用webservice接口。呵呵~                    --调用webService---------------- declare @ServiceUrl as varchar(1000) DECLARE @UrlAddress varchar(500) --WebService地址：以http开头，结尾
都2020年了还能看见奇葩的SQL写法
落落的专栏 专注SQL调优 性能调优
08-17 1453
安鸾渗透实战平台-sql注入篇
weixin_48421613的博客
01-04 3397
sql注入篇 安鸾渗透实战平台是一个在线的靶场平台，需要通过一些列手段找到flag提交 文章目录sql注入篇SQL字符型注入（1-2）一、需识别mysql默认的information库二、内部结构1.schemata表内容2.tables表内容3.columns表内容4.解题思路SQL搜索型注入总结 SQL字符型注入（1-2） 开始忘记截图了，只好给大家直接写一下payload了 提示：仅适合参考 一、需识别mysql默认的information库 mysql 5.0版本以上会有一个默认的infor
elasticsearch-sql--介绍
IT利刃出鞘的博客
12-27 1358
其他网址 es 6.3内置sql vs NLPChina elasticsearch-sql | 甲鱼的大数据之旅
heidisql ssh mysql_heidisql使用小技巧
weixin_39625864的博客
01-27 1339
heidisql这个开源的mysql客户端连接工具很好用，它能显示很多mysql的运行参数，对于DBA或者偏sql的运维人员非常适用。heidisql连接mysql server常用2种方式：1、tcp连接2、ssh 隧道模式第一种方法很简单，直接在mysql server上通过grant命令授权个当前IP的用户即可。但是有时候我们生产环境的数据库做了限制，最高权限只能在localhost上进行连...
Spark sql 常见问题及优化
Jhon_yh的博客
03-16 3493
目录数据倾斜1.null值的处理2.持续整理中... 数据倾斜 1.null值的处理 INSERT OVERWRITE TABLE tf_lte_prd_pd_inst_month PARTITION (month_id) SELECT prvnce_id, std_prvnce_cd ,... FROM ( SELECT '${V_DATE}' month_id ,..., C...
html5微信小游戏源码 奇葩连连看游戏源码（仅用于参考）
01-25
html5微信小游戏源码 奇葩连连看游戏源码（仅用于参考）html5微信小游戏源码 奇葩连连看游戏源码（仅用于参考）html5微信小游戏源码 奇葩连连看游戏源码（仅用于参考）html5微信小游戏源码 奇葩连连看游戏源码（仅...
MS SQLSERVER通用存储过程分页
01-19
近在面试的时候，遇到个奇葩的秃顶老头面试官。 　问：写过存储过程分页吗？...只在SQLSERVER2008上测试过，不过我想，2000以上版本应该都会支持的吧。 　废话到此，上代码。 if (object_id('Pro
微信小游戏源码 奇葩连连看游戏源码（仅用于学习参考）
01-25
微信小游戏源码 奇葩连连看游戏源码（仅用于学习参考）微信小游戏源码 奇葩连连看游戏源码（仅用于学习参考）微信小游戏源码 奇葩连连看游戏源码（仅用于学习参考）微信小游戏源码 奇葩连连看游戏源码（仅用于学习...
安卓奇葩音乐播放器源码
09-28
为您提供安卓奇葩音乐播放器源码下载， 安卓奇葩音乐播放器源码是个奇葩其实一点也不冤枉这个项目，整个播放器只有一个循环播放的动画画面，打开软件会自动扫描SD卡上的音乐并且把少于一分钟的音频过滤掉然后随机...
毕业设计论文SpringBoot社区老人健康信息管理系统.docx
10-17
毕业设计论文
TEAM-NAVI-Requirements Specification Document
10-17
TEAM_NAVI_Requirements Specification Document
分析流体动力学中的混沌系统-解决混沌系统问题python源码+项目说明（课程作业）.zip
最新发布
10-17
1.多数小白下载后，在使用过程，可能会遇到些小问题，若自己解决不了，请及时私信描述你的问题，我会第一时间提供帮助，也可以远程指导 2.项目代码完整可靠，谈不上高分、满分(多数为夸大其词），但难度适中，满足一些毕设、课设要求，且属于易上手的优质项目，项目内基本都有说明文档，按照操作即可，遇到困难也可私信交流 3.适用人群：各大计算机相关专业行业的在校学生、高校老师、公司程序员等下载使用 4.特别是那种爱钻研学习的学霸，强烈推荐此项目，可以二次开发提升自己。如果确定自己是学渣，拿来作毕设、课设直接用也无妨，但建议自己还是尽可能弄懂项目最好！ 项目名字和项目路径不要用中文，建议解压重命名为英文名字后再运行！项目易上手运行
毕业设计论文SpringBoot教学辅助系统.docx
10-17
毕业设计论文
奇葩连连看微信小游戏源码解析
'奇葩连连看'是一种流行的消除类游戏，在这里提及的游戏源码很可能包含游戏的基本逻辑、界面设计、交互控制、得分系统、动画效果等方面。开发者可以参考这套源码来了解如何构建一款小游戏的框架，以及如何将游戏逻辑...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值