SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:22

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.003

SELECT a.CKDH00,a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00,decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00,

 DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000,a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00,

 a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*)  from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00

 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00,

 decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0,decode(a.BYJXX0,'QZFYBYJ','已摆药','' ) BYJXX0

 FROM YF_YZYPSQ a WHERE ZYID00=:1

 AND a.BQBMBH=:2

 AND a.YFBMBH=:3

  AND a.CLBZ00  like '%'

  AND a.QLZT00 IN('0','1')

  AND a.HZBZ00='1' 

  AND a.FYBZ00='1' 

  AND a.CXBZ00='Z'

  AND nvl(a.SHBZ00,'0') LIKE :4  

  ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID   


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:23

SELECT a.CKDH00,a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00,decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00,

 DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000,a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00,

 a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*)  from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00

 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00,

 decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0,decode(a.BYJXX0,'QZFYBYJ','已摆药','' ) BYJXX0

 FROM YF_YZYPSQ a WHERE ZYID00=0.159289600e+007

 AND a.BQBMBH=0.211000000e+003

 AND a.YFBMBH=0.440000000e+002

  AND a.CLBZ00  like '%'

  AND a.QLZT00 IN('0','1')

  AND a.HZBZ00='1' 

  AND a.FYBZ00='1' 

  AND a.CXBZ00='Z'

  AND nvl(a.SHBZ00,'0') LIKE '%'  

  ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID   




:1=[0.159289600e+007]
:2=[0.211000000e+003]
:3=[0.440000000e+002]
:4=['%']


Elapsed time: 0.002

SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:23

SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL




Elapsed time: 0.001

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:23

Commit




Elapsed time: 0.001

BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_BYFHR0 => :P_BYFHR0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE,P_SHBZ00 => :P_SHBZ00); END;
Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:23

BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_BYFHR0 => :P_BYFHR0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE,P_SHBZ00 => :P_SHBZ00); END;


:1=['誏`M']
:2=['誏`M']
:3=['誏`M']
:4=['誏`M']
:5=['誏`M']
:6=['誏`M']
:7=['誏`M']
:8=['誏`M']
:9=['誏`M']
:10=['誏`M']
:11=['誏`M']
:12=['誏`M']
:13=['誏`M']
P_YPNM00=['']
P_YFBMBH=[0.440000000e+002]
P_BQBMBH=[0.211000000e+003]
P_ZYID00=[0.159289600e+007]
P_CLBZ00=['']
P_HZBZ00=['1']
P_CZYBH0=[0.100000000e+001]
P_LYRBH0=[-0.100000000e+001]
P_FHRBH0=[-0.100000000e+001]
P_BYFHR0=[-0.100000000e+001]
P_CKDH00=['276557']
P_MESSAGE=[NULL]
P_SHBZ00=[NULL]


Elapsed time: 0.041

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:23

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:23

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

commit




Elapsed time: 0.001

SELECT '儿科病区1' BQBMMC,ROUND(SUM(LSDJ00*YPZSL0),2) CFJE00,

 '测试人员5' CZR000,TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') CZRQ00 

 FROM YF_YZYPSQ A 

 WHERE  CKDH00='276557'


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

SELECT '儿科病区1' BQBMMC,ROUND(SUM(LSDJ00*YPZSL0),2) CFJE00,

 '测试人员5' CZR000,TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') CZRQ00 

 FROM YF_YZYPSQ A 

 WHERE  CKDH00='276557'




Elapsed time: 0.005

SELECT A.*,(JYF000+JE0000) HJJE01 FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 ORDER BY A.CH0000,A.ZYID00,CLBZ00,A.YZID00


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

SELECT A.*,(JYF000+JE0000) HJJE01 FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 ORDER BY A.CH0000,A.ZYID00,CLBZ00,A.YZID00




Elapsed time: 0.034

SELECT SUM(HJJE00) ZYDJF0 FROM ZY_FYMX00 WHERE DJH000 IN (SELECT DISTINCT FJFDJH FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 and A.ZYID00 = :1

)


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

SELECT SUM(HJJE00) ZYDJF0 FROM ZY_FYMX00 WHERE DJH000 IN (SELECT DISTINCT FJFDJH FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 and A.ZYID00 = 0.159289600e+007

)




:1=[0.159289600e+007]


Elapsed time: 0.013

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT SUM(HJJE00) ZYDJF0 FROM ZY_FYMX00 WHERE DJH000 IN (SELECT DISTINCT FJFDJH FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 and A.ZYID00 = :1

)


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

SELECT SUM(HJJE00) ZYDJF0 FROM ZY_FYMX00 WHERE DJH000 IN (SELECT DISTINCT FJFDJH FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 and A.ZYID00 = 0.159289600e+007

)




:1=[0.159289600e+007]


Elapsed time: 0.002

SELECT SUM(HJJE00) ZYDJF0 FROM ZY_FYMX00 WHERE DJH000 IN (SELECT DISTINCT FJFDJH FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 and A.ZYID00 = :1

)


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

SELECT SUM(HJJE00) ZYDJF0 FROM ZY_FYMX00 WHERE DJH000 IN (SELECT DISTINCT FJFDJH FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='276557'

 and A.ZYID00 = 0.159289600e+007

)




:1=[0.159289600e+007]


Elapsed time: 0.001

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:24

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:25

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

 SELECT A.*  FROM VW_YF_ZDYKFLYD_DSQL A WHERE 1=1 

 and A.CKDH00='276557'


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:25

 SELECT A.*  FROM VW_YF_ZDYKFLYD_DSQL A WHERE 1=1 

 and A.CKDH00='276557'




Elapsed time: 0.008

 SELECT A.*  FROM VW_YF_ZDYKFLYD_DSQL A WHERE 1=1 

 and A.CKDH00='276557'


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:25

 SELECT A.*  FROM VW_YF_ZDYKFLYD_DSQL A WHERE 1=1 

 and A.CKDH00='276557'




Elapsed time: 0.002

SELECT DISTINCT BRXM00,ZYID00,BQBMBH,YFBMBH,ZYH000,CH0000 

,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00 

FROM YF_YZYPSQ a 

WHERE BQBMBH=211

and YFBMBH=44

AND QLZT00 IN ('0','1') AND HZBZ00='1' AND FYBZ00='1' 

 AND CXBZ00='Z' 

AND nvl(SHBZ00,'0') like '%' 

ORDER BY CH0000


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

SELECT DISTINCT BRXM00,ZYID00,BQBMBH,YFBMBH,ZYH000,CH0000 

,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00 

FROM YF_YZYPSQ a 

WHERE BQBMBH=211

and YFBMBH=44

AND QLZT00 IN ('0','1') AND HZBZ00='1' AND FYBZ00='1' 

 AND CXBZ00='Z' 

AND nvl(SHBZ00,'0') like '%' 

ORDER BY CH0000




Elapsed time: 0.002

SELECT COUNT(1) as Counter FROM YF_YZYPSQ

 WHERE BQBMBH=211

 AND YFBMBH=44

 AND QLZT00 IN ('0','1')

 AND CXBZ00='Z'

 AND THBZ00='0'


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

SELECT COUNT(1) as Counter FROM YF_YZYPSQ

 WHERE BQBMBH=211

 AND YFBMBH=44

 AND QLZT00 IN ('0','1')

 AND CXBZ00='Z'

 AND THBZ00='0'




Elapsed time: 0.001

UPDATE BM_BQFYZT SET FYZT00='1'

 WHERE YFBMBH=44

   AND BQBMBH=211


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

UPDATE BM_BQFYZT SET FYZT00='1'

 WHERE YFBMBH=44

   AND BQBMBH=211




Elapsed time: 0.001

UPDATE YF_YZYPSQ SET FYBZ00='0'

 WHERE YFBMBH=44

   AND BQBMBH=211

   AND QLZT00 IN ('0','1')

   AND FYBZ00 <>'0'


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

UPDATE YF_YZYPSQ SET FYBZ00='0'

 WHERE YFBMBH=44

   AND BQBMBH=211

   AND QLZT00 IN ('0','1')

   AND FYBZ00 <>'0'




Elapsed time: 0.002

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

COMMIT




Elapsed time: 0.002

 select SF_YF_CHECKSFZSM(:1,:2) as FHXX00 from dual 


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

 select SF_YF_CHECKSFZSM('276557','1') as FHXX00 from dual 




:1=['276557']
:2=['1']


Elapsed time: 0.002

 select SF_SF_TYZD00(:1,:2)FHJG00 from dual


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

 select SF_SF_TYZD00('医保追溯码配置','YBZSMSFQY_ZY')FHJG00 from dual




:1=['医保追溯码配置']
:2=['YBZSMSFQY_ZY']


Elapsed time: 0.003

select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YBZSMSFQY_ZY'


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YBZSMSFQY_ZY'




Elapsed time: 0.001

select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'QZCS_ZY'


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'QZCS_ZY'




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:27

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.003

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:28

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.016

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:29

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.001

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:30

Rollback




Elapsed time: 0.001

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:31

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:34

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:35

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:35

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.003

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:36

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:36

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:37

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:39

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.002

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:39

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.001

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: illegal variable name/number
)

--------------------------------------------------------------------------------
Timestamp: 2024-12-11 16:23:41

SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 

where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')

 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '44')

  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  




Elapsed time: 0.001