| SQL Id | SQL Text |
|---|
| 00cqvrnt9hdmu |
select * from ( select my_table.*, rownum as my_rownum from ( select tableA.*, rownum as r from ( select a.id, a.docsubject, b.doccontent, a.doclastmoddate, a.doclastmodtime, a.doccreaterid, a.usertype, a.doccreatedate, a.doccreatetime from DocDetail a, DocDetailContent b where a.id in (select distinct t1.id from DocDetail t1, (SELECT sourceid, sharelevel from ShareinnerDoc where((type=1 and content=515) or (type=2 and content=1 and seclevel<=80) or (type=3 and content=41 and
seclevel<=80) or (type=4 and content in (1222) and seclevel<=80) or (type=5 and content = 1 and seclevel<=80)) ) t2, DocDetailContent t3 where t1.id=t2.sourceid and t1.id = t3.docid and (ishistory is null or ishistory = 0) and seccategory in(285) and (docstatus='1' or docstatus='2' or docstatus='5' or docstatus = 7 and (sharelevel>1 or (doccreaterid=515 or ownerid=515)) ) and (isreply!=1 or isreply is null) ) and a.id=b.docid order by (case when a.istop is null then 0 el
se a.istop end) desc, (case when a.topdate is null or a.istop is null then '1900-01-01' else a.topdate end) desc, (case when a.toptime is null or a.istop is null then '00:00:00' else a.toptime end) desc, a.doclastmoddate desc, a.doclastmodtime desc, a.id desc) tableA ) my_table where rownum < 4 ) where my_rownum > 0
|
| 00y18tpxh10cu |
select * from ( select my_table.*, rownum as my_rownum from ( select tableA.*, rownum as r from ( select a.id, a.docsubject, b.doccontent, a.doclastmoddate, a.doclastmodtime, a.doccreaterid, a.usertype, a.doccreatedate, a.doccreatetime from DocDetail a, DocDetailContent b where a.id in (select distinct t1.id from DocDetail t1, (SELECT sourceid, sharelevel from ShareinnerDoc where((type=1 and content=5193) or (type=2 and content=1 and seclevel<=20) or (type=3 and content=27 an
d seclevel<=20) or (type=5 and content = 1 and seclevel<=20)) ) t2, DocDetailContent t3 where t1.id=t2.sourceid and t1.id = t3.docid and (ishistory is null or ishistory = 0) and seccategory in(701, 703, 722, 724, 728, 730, 725, 727, 731, 733, 734, 736, 737, 739, 721, 741, 742, 744, 745, 747, 748, 750, 761, 801, 763, 802, 1001, 1002) and (docstatus='1' or docstatus='2' or docstatus='5' or docstatus = 7 and (sharelevel>1 or (doccreaterid=5193 or ownerid=5193)) ) and (isreply!=1 o
r isreply is null) ) and a.id=b.docid order by (case when a.istop is null then 0 else a.istop end) desc, (case when a.topdate is null or a.istop is null then '1900-01-01' else a.topdate end) desc, (case when a.toptime is null or a.istop is null then '00:00:00' else a.toptime end) desc, a.doclastmoddate desc, a.doclastmodtime desc, a.id desc) tableA ) my_table where rownum < 11 ) where my_rownum > 0
|
| 016vn20usc708 | select count(t1.id) from DocDetail t1, (SELECT sourceid, MAX(sharelevel) AS sharelevel from ShareinnerDoc where((type=1 and content=4984) or (type=2 and content=21 and seclevel<=20) or (type=3 and content=79 and seclevel<=20) or (type=5 and content = 1 and seclevel<=20)) GROUP BY sourceid ) t2, docsubcategory t3 where ( ( t1.docstatus = 7 and (sharelevel>1 or (t1.doccreaterid=498
4)) ) or t1.docstatus in ('1', '2', '5') ) and maincategory!=0 and subcategory!=0 and seccategory!=0 and maincategory in(13, 161) and t1.subcategory=t3.id and (ishistory is null or ishistory = 0) and t1.id=t2.sourceid |
| 0189sr35n1h92 | select * from ( select my_table.*, rownum as my_rownum from ( select tableA.*, rownum as r from ( select t1.id, t1.seccategory, t1.doclastmodtime, ('?'||t3.categoryname||'?'||t1.docsubject||' '||t1.doccode)as docsubject, t2.sharelevel, t1.docextendname, t1.doccode, doclastmoddate, sumReadCount, docstatus, sumMark from DocDetail t1, (SELECT sourceid, MAX(sharelevel) AS sharelevel from S
hareinnerDoc where((type=1 and content=3010) or (type=2 and content=25 and seclevel<=20) or (type=3 and content=266 and seclevel<=20) or (type=5 and content = 1 and seclevel<=20)) GROUP BY sourceid ) t2, docsubcategory t3 where ( ( t1.docstatus = 7 and (sharelevel>1 or (t1.doccreaterid=3010)) ) or t1.docstatus in ('1', '2', '5') ) and maincategory!=0 and subcategory!=0 and seccategory!=0 and maincategory in(13, 161) and t1.subcategory=t3.id and (ishistory is null or ishisto
ry = 0) and t1.id=t2.sourceid order by doclastmoddate desc, doclastmodtime desc, t1.id desc) tableA ) my_table where rownum < 16 ) where my_rownum > 0 |
| 4sxj137h9y76z | select count(*) from HrmResource where status in (0, 1, 2, 3) and loginid is not null |
| 7gwxpwru0czqw | select companyname from license |
| 9uyrq2wh9k8f7 | select hash_value, substr(sql_text, 1, 100)
from v$sqlarea
where substr(sql_text, 1, 40) in(
select substr(sql_text, 1, 40) from v$sqlarea
having count(*) >50
group by substr(sql_text, 1, 40)) |
| gvt65jbd7wst4 | select * from ( select my_table.*, rownum as my_rownum from ( select tableA.*, rownum as r from ( select t1.id, t1.seccategory, t1.doclastmodtime, ('?'||t3.categoryname||'?'||t1.docsubject||' '||t1.doccode)as docsubject, t2.sharelevel, t1.docextendname, t1.doccode, doclastmoddate, sumReadCount, docstatus, sumMark from DocDetail t1, (SELECT sourceid, MAX(sharelevel) AS sharelevel from S
hareinnerDoc where((type=1 and content=4677) or (type=2 and content=29 and seclevel<=20) or (type=3 and content=360 and seclevel<=20) or (type=5 and content = 1 and seclevel<=20)) GROUP BY sourceid ) t2, docsubcategory t3 where ( ( t1.docstatus = 7 and (sharelevel>1 or (t1.doccreaterid=4677)) ) or t1.docstatus in ('1', '2', '5') ) and maincategory!=0 and subcategory!=0 and seccategory!=0 and maincategory in(13, 161) and t1.subcategory=t3.id and (ishistory is null or ishisto
ry = 0) and t1.id=t2.sourceid order by doclastmoddate desc, doclastmodtime desc, t1.id desc) tableA ) my_table where rownum < 11 ) where my_rownum > 0 |
| gy7u2brsskqav | select count(t1.id) from DocDetail t1, (SELECT sourceid, MAX(sharelevel) AS sharelevel from ShareinnerDoc where((type=1 and content=900) or (type=2 and content=21 and seclevel<=20) or (type=3 and content=79 and seclevel<=20) or (type=5 and content = 1 and seclevel<=20)) GROUP BY sourceid ) t2, docsubcategory t3 where ( ( t1.docstatus = 7 and (sharelevel>1 or (t1.doccreaterid=900)
) ) or t1.docstatus in ('1', '2', '5') ) and maincategory!=0 and subcategory!=0 and seccategory!=0 and maincategory in(13, 161) and t1.subcategory=t3.id and (ishistory is null or ishistory = 0) and t1.id=t2.sourceid |
| gzds7jrfpsgrt |
select * from ( select my_table.*, rownum as my_rownum from ( select tableA.*, rownum as r from ( select a.id, a.docsubject, b.doccontent, a.doclastmoddate, a.doclastmodtime, a.doccreaterid, a.usertype, a.doccreatedate, a.doccreatetime from DocDetail a, DocDetailContent b where a.id in (select distinct t1.id from DocDetail t1, (SELECT sourceid, sharelevel from ShareinnerDoc where((type=1 and content=51) or (type=2 and content=1 and seclevel<=20) or (type=3 and content=26 and
seclevel<=20) or (type=5 and content = 1 and seclevel<=20)) ) t2, DocDetailContent t3 where t1.id=t2.sourceid and t1.id = t3.docid and (ishistory is null or ishistory = 0) and seccategory in(701, 703, 722, 724, 728, 730, 725, 727, 731, 733, 734, 736, 737, 739, 721, 741, 742, 744, 745, 747, 748, 750, 761, 801, 763, 802, 1001, 1002) and (docstatus='1' or docstatus='2' or docstatus='5' or docstatus = 7 and (sharelevel>1 or (doccreaterid=51 or ownerid=51)) ) and (isreply!=1 or isr
eply is null) ) and a.id=b.docid order by (case when a.istop is null then 0 else a.istop end) desc, (case when a.topdate is null or a.istop is null then '1900-01-01' else a.topdate end) desc, (case when a.toptime is null or a.istop is null then '00:00:00' else a.toptime end) desc, a.doclastmoddate desc, a.doclastmodtime desc, a.id desc) tableA ) my_table where rownum < 11 ) where my_rownum > 0
|
| gztqvr3hspqgv | select * from ( select my_table.*, rownum as my_rownum from ( select tableA.*, rownum as r from ( select a.id, a.docsubject, b.doccontent, a.doclastmoddate, a.doclastmodtime, a.doccreaterid, a.usertype, a.doccreatedate, a.doccreatetime from DocDetail a, DocDetailContent b where a.id in (select distinct t1.id from DocDetail t1, (SELECT sourceid, sharelevel from ShareinnerDoc where((type
=1 and content=3248) or (type=2 and content=21 and seclevel<=20) or (type=3 and content=64 and seclevel<=20) or (type=5 and content = 1 and seclevel<=20)) ) t2, DocDetailContent t3 where t1.id=t2.sourceid and t1.id = t3.docid and (ishistory is null or ishistory = 0) and seccategory in(291, 292, 293, 294) and (docstatus='1' or docstatus='2' or docstatus='5' or docstatus = 7 and (sharelevel>1 or (doccreaterid=3248 or ownerid=3248)) ) and (isreply!=1 or isreply is null) ) an
d a.id=b.docid order by (case when a.istop is null then 0 else a.istop end) desc, (case when a.topdate is null or a.istop is null then '1900-01-01' else a.topdate end) desc, (case when a.toptime is null or a.istop is null then '00:00:00' else a.toptime end) desc, a.doclastmoddate desc, a.doclastmodtime desc, a.id desc) tableA ) my_table where rownum < 6 ) where my_rownum > 0 |