1       17:58:18  SQL Execute: ORACLE - update jy_ZKJG00 set ZKJG00=53.410 where YBH000='L20996' and ZKBBPH='45932' and BGXMID='113799' and YQDH00='L2' and ZXRQ00='20230323' and XH0000=1

2       17:58:18  SQL Data In: ORACLE - Rows affected = 1
3       17:58:18  SQL Execute: ORACLE - select count(*) from jy_ZKJG00  where YBH000='L20996' and ZKBBPH='45932' and BGXMID='113799' and YQDH00='L2' and ZXRQ00='20230323'

4       17:58:18  SQL Execute: ORACLE -  update JY_JYJG00_TEMP  set JYJG00='53.410',      BZ0000='ÖÊ¿ØдÈë'  where YBH000='L20996'    and nvl(YQJCRQ,BGRQ00)='20230323'    and BGXMID='113799' 

5       17:58:19  SQL Data In: ORACLE - Rows affected = 1
6       17:58:19  SQL Execute: ORACLE -  insert into JY_JYJG00_TEMP(YQDH00,YBH000,BGXMID,PYRQ00,YQJCRQ,BGRQ00,JYJG00,BZ0000)  select 'L2' YQDH00,         'L20996' YBH000,         '113799' BGXMID,         '20230323' PYRQ00,         '20230323' YQJCRQ,         '20230323' BGRQ00,         '53.410' JYJG00,         'ÖÊ¿ØдÈë' BZ0000  from dual  where not exists(select 1 from JY_JYJG00_TEMP                   where YBH000='L20996'                     and nvl(YQJCRQ,BGRQ00)='20230323'                     and BGXMID='113799') 

7       17:58:19  SQL Data In: ORACLE - Rows affected = 0
8       17:58:19  SQL Execute: ORACLE - commit

9       17:58:19  SQL Data In: ORACLE - Rows affected = 0