20211104  17:15:44   SELECT count(1) num   from VW_HT_XTTSXX_DZBL a  where rownum <= 2000 and  yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')    and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = ?)) or XXXZ00 = '0')    AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = ?  )  and (  (INSTR(',' || a.jsksbh || ',', ',478,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1269,') > 0 and FSDX00='2') ) 
/* parameters:  [<OE>^<1269>] */

20211104  17:15:44   SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,BRID00   FROM Vw_ht_xttsxx_dzbl a  where rownum <= 2000 and  yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')       AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = ?  )  and (  (INSTR(',' || a.jsksbh || ',', ',478,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1269,') > 0 and FSDX00='2') )  and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = ?)) or XXXZ00 = '0')   order by a.XH0000 desc
/* parameters:  [<1269>^<OE>] */

20211104  17:14:44   SELECT count(1) num   from VW_HT_XTTSXX_DZBL a  where rownum <= 2000 and  yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')    and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = ?)) or XXXZ00 = '0')    AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = ?  )  and (  (INSTR(',' || a.jsksbh || ',', ',478,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1269,') > 0 and FSDX00='2') ) 
/* parameters:  [<OE>^<1269>] */

20211104  17:14:44   SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,BRID00   FROM Vw_ht_xttsxx_dzbl a  where rownum <= 2000 and  yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')       AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = ?  )  and (  (INSTR(',' || a.jsksbh || ',', ',478,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1269,') > 0 and FSDX00='2') )  and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = ?)) or XXXZ00 = '0')   order by a.XH0000 desc
/* parameters:  [<1269>^<OE>] */

20211104  17:14:11  SELECT * FROM Yj_ywmx00 where 1 = 1  and yjdjh0 = ? 
/* parameters:  [<37671149>] */

20211104  17:14:10  SELECT * FROM Yj_ywmx00 where 1 = 1  and yjdjh0 = ? 
/* parameters:  [<37671145>] */

20211104  17:14:10    Select brid00,yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,xb0000,csrq00,lrxm00,kdsj00,zje000,  decode(b.xmzt00,'0','新开','1','已定价','2','已收费','3','已执行','4','已报告','5','疑退','6','作废') xmzt00,    mzzybz,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,sl0000,zxsl00,cxdjh0,cxsl00,kdys00,yjksbh,zxrq00,zxsj00,zxrxm0,yjksmc from VW_YJ_YW0000_KCX_MZDZBL b  where xmzt00 not in('0','6','7')    and SL0000>nvl(CXSL00,0) and SL0000>0   and SFDJH0<>0 and XMZT00 <>'1'    and ((yjlrbz='N') or (zxsl00<>0))   and kdrq00 between ? and ?  and  BRID00 = ?   and (YJKSBH=? and xmzt00='3' or KDKSBH=? and xmzt00 in('1','2') )  and  MZZYBZ = ?    order by yjdjh0
/* parameters:  [<20210924>^<20211105>^<4269657>^<478>^<478>^<0>] */

20211104  17:14:09    Select brid00,zyghid,yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,xb0000,csrq00,lrxm00,kdsj00,zje000,  decode(b.xmzt00,'0','新开','1','已定价','2','已收费','3','已执行','4','已报告','5','疑退','6','作废') xmzt00,    mzzybz,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,sl0000,zxsl00,cxdjh0,cxsl00,kdys00,yjksbh,zxrq00,zxsj00,zxrxm0,yjksmc from vw_yj_yw0000 b  where xmzt00 in('0','1','2')    and yjlrbz='N'   and kdrq00 between ? and ?  and  BRID00 = ?  and YJKSBH = ? and MZZYBZ = ?   order by yjdjh0
/* parameters:  [<20210924>^<20211105>^<4269657>^<478>^<0>] */

20211104  17:14:09  {call SP_YJ_GETBRXX(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
/* parameters:  [<PBRID00~in out~2~4269657>^<PMZZYBZ~in out~12~0>^<PZYHGHH~in out~12~null>^<PZYGHID~out~2~null>^<PXM0000~out~12~null>^<PXB0000~out~12~null>^<PCH0000~out~12~null>^<PYBLB00~out~12~null>^<PFBBH00~out~12~null>^<PFBMC00~out~12~null>^<PYBBRLB~out~12~null>^<PYBMC00~out~12~null>^<PKSMC00~out~12~null>^<PCSRQ00~out~12~null>^<PMZYE00~out~2~null>^<PZYYE00~out~2~null>^<PBRNL00~out~12~null>] */

20211104  17:14:09   select a.*,b.ickh00,b.kmh000 from vw_ys_brxxb0_mzdzbl a,(select * from ic_yhxx00 where zt0000='1') b where rownum <= 2000 and  a.BRID00 = b.brid00(+)   and a.BRID00=?  and b.ickh00 =? 
/* parameters:  [<4269657>^<FZYBAA6252638>] */

20211104  17:14:09  SELECT * FROM IC_YHXX00 WHERE rownum <= 2000 and  1=1AND ICKH00 =? AND ICKNBH =? 
/* parameters:  [<FZYBAA6252638>^<FZYBAA6252638>] */

20211104  17:14:09  SELECT * FROM IC_YHXX00 WHERE rownum <= 2000 and  1=1AND ICKH00 =? 
/* parameters:  [<FZYBAA6252638>] */

20211104  17:13:43  select to_char(sysdate,'d') d from dual
/*  */

20211104  17:13:43  select count(*) from BM_TYZD00 where ZDMC00='节假日信息维护' and MC0000=to_char(sysdate,'YYYYMMDD')
/*  */

20211104  17:13:43  select DYZYKS  displayname, to_char((select bmmc00 from bm_bmbm00 where bmbh00=a.dyzyks))  cmbvalue from BM_BMBM00 a   where BMBH00=478
/*  */

20211104  17:13:43  select * from bm_tyzd00 where zdmc00 = '合理用药' and bz0000 like  '%颜色%' order by xsxh00 
/*  */

20211104  17:13:43  select BH0000,MC0000 from BM_TYZD00 where ZDMC00='瑞博接口' and (nvl(BH0001,' ')=' ' or BH0001='220035')
/*  */