基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS 
FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;

alter system kill session '127,41279'; 




select a.*  from(
select a.ennmcd,a.rtlv,a.dhglv,a.INMSGTM,b.RVNM,c.ennm,c.wrz,e.prf,d.wddr,d.wdsp from U_ST_RLWT a
left join U_PFST_BSINFO b on (a.ENNMCD = b.ENNMCD)
left join U_PFST_HDRFLMS  c on (b.ENNMCD = c.ENNMCD)
left join  U_ST_STWDST d on (c.ENNMCD = d.ENNMCD)
left join  U_ST_STRNST e on (d.ENNMCD = e.ENNMCD) ）a ,
(select t.ENNMCD,max(t.tm)tm from U_ST_STRNST t  group by t.ENNMCD) b 
 where a.ENNMCD=b.ENNMCD and a.INMSGTM = b.tm



select a.*  from(
select a.ennmcd,a.rtlv,a.dhglv,a.INMSGTM,b.RVNM,c.ennm,c.wrz,d.prf,e.wddr,e.wdsp from U_ST_RLWT a
left join U_PFST_BSINFO b on (a.ENNMCD = b.ENNMCD)
left join U_PFST_HDRFLMS  c on (b.ENNMCD = c.ENNMCD)
left join   U_ST_STRNST d on (c.ENNMCD = d.ENNMCD)
left join   U_ST_STWDST e on (a.ENNMCD = e.ENNMCD) )a ,
(select t.ENNMCD,max(t.tm)tm from U_ST_STRNST t  group by t.ENNMCD) b 
 where a.ENNMCD=b.ENNMCD and a.INMSGTM = b.tm
 
 select a.*  from(
select a.ennmcd,c.rtlv,c.dhglv,c.INMSGTM,a.RVNM,b.ennm,b.wrz,d.INMSGPRF,e.wddr,e.wdsp from U_PFST_BSINFO a
left join U_PFST_HDRFLMS b on (a.ENNMCD = b.ENNMCD)
left join U_ST_RLWT  c on (b.ENNMCD = c.ENNMCD)
left join   U_ST_RLRN d on (c.ENNMCD = d.ENNMCD)
left join   U_ST_STWDST e on (d.ENNMCD = e.ENNMCD) )a ,
(select t.ENNMCD,max(t.tm)tm from U_ST_STRNST t  group by t.ENNMCD) b 
 where a.ENNMCD=b.ENNMCD and a.INMSGTM = b.tm



select cast(a.stcdt as varchar(12)),a.ymdhm,a.zu,a.zd,b.ennm,b.wrz,c.ln,c.lt,c.stad from(
select * from (
 select  stcdt,ymdhm,zu,zd from gzguest.U_ST_DAM_R  where ymdhm in (select max(ymdhm) from gzguest.U_ST_DAM_R 
  group by stcdt having count(*)>1)) a)  a 
  left join gzguest.U_PFST_HDRFLMS b on (a.stcdt = b.ENNMCD )
  left join gzguest.u_pfst_bsinfo c on (b.ENNMCD = c.ENNMCD )
  where a.stcdt = b.ENNMCD  and b.ENNMCD = c.ENNMCD   and                                   
  a.ymdhm < sysdate and a.ymdhm >= sysdate - 1  
  order by c.stad,a.ymdhm desc


select ennmcd,max(tm)as tm,sum(prf)as prf from (
select ennmcd,tm,sum(prf)as prf from(
select t.ennmcd as ennmcd,substr(to_char(t.tm,'yyyy/mm/dd hh24:mi:ss'),1,13)as tm,sum(t.prf)as prf 
from gzguest.U_ST_STRNST t where  tm >= sysdate -24/24 and tm <= sysdate  group by  t.ennmcd ,tm) where ennmcd='C440184111' 
group by ennmcd,tm  order by tm desc 
) group by ennmcd


select ennmcd,tm, prf from gzguest.U_ST_STRNST  where  tm >=
                       to_date('2015-07-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
                   and tm <
                       to_date('2015-09-02 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
 and ennmcd = 'C440100011'  order by prf desc