declare n number;begin  select count(*) into n from user_tables where table_name ='R2_CWSJ00'; if n<1 then execute immediate 'CREATE TABLE R2_CWSJ00 (INSERT_ODS_TIME DATE NOT NULL,UPDATE_ODS_TIME DATE NOT NULL)'; end if; end;

declare n number;begin  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALMONTH'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALMONTH varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'TVALUE1'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD TVALUE1 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSJZFL1'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSJZFL1 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSCPFL'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSCPFL varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALDAY'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALDAY varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSMXX'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSMXX varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'VALUE1_SUM'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD VALUE1_SUM varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'SJZT'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD SJZT varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSDLTXT'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSDLTXT varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'SDATE'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD SDATE varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBHQDZ'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBHQDZ varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'BZ'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD BZ varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALJJQ27'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALJJQ27 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBBZ'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBBZ varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'UPDATED_USER'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD UPDATED_USER varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'VALUE1'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD VALUE1 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALYEAR'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALYEAR varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBLYMS'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBLYMS varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBBM'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBBM varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBCXGJC'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBCXGJC varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBLHCXBS'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBLHCXBS varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBHQFSMS'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBHQFSMS varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALWEEK'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALWEEK varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'TVALUE2'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD TVALUE2 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBDW'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBDW varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSJLX'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSJLX varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALJJQ28'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALJJQ28 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBLX'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBLX varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSORDER1'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSORDER1 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBMS'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBMS varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'INUSE'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD INUSE varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'VALUE2'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD VALUE2 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALQUART'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALQUART varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALJJQ25'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALJJQ25 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBHQFS'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBHQFS varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSJZFL'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSJZFL varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBLY'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBLY varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBSTRQFL'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBSTRQFL varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'EDATE'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD EDATE varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'ZBLXMS'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD ZBLXMS varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALJJQ26'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALJJQ26 varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'CALTIME'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD CALTIME varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'UPDATED_TIMESTAMP'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD UPDATED_TIMESTAMP varchar(255)  NULL'; end if;  select count(*) into n from user_tab_cols where table_name = 'R2_CWSJ00' and column_name = 'SCZT'; if n<1 then execute immediate 'ALTER TABLE R2_CWSJ00 ADD SCZT varchar(255)  NULL'; end if; select 1 into n  from dual;end;

declare n number;begin MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBCRD0020DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221124' as CALDAY,'数据爬取' as ZBSMXX,'85.484999' as VALUE1_SUM,'' as SJZT,'布伦特现货' as ZBSDLTXT,'20221124' as SDATE,'' as ZBHQDZ,'' as BZ,'' as CALJJQ27,'' as ZBBZ,'mail' as UPDATED_USER,'85.485' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBCRD0020DD' as ZBBM,'布伦特 现货（日）' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'美元/桶' as ZBDW,'D' as ZBSJLX,'' as CALJJQ28,'CRD' as ZBLX,'9999' as ZBSORDER1,'布伦特现货' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'油价快报导入指标' as ZBLXMS,'' as CALJJQ26,'20221124' as CALTIME,'2022/11/25 7:41:23' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221124',ZBSMXX='数据爬取',VALUE1_SUM='85.484999',SJZT='',ZBSDLTXT='布伦特现货',SDATE='20221124',ZBHQDZ='',BZ='',CALJJQ27='',ZBBZ='',UPDATED_USER='mail',VALUE1='85.485',CALYEAR='2022',ZBLYMS='',ZBBM='ZBCRD0020DD',ZBCXGJC='布伦特 现货（日）',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='美元/桶',ZBSJLX='D',CALJJQ28='',ZBLX='CRD',ZBSORDER1='9999',ZBMS='布伦特现货',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='油价快报导入指标',CALJJQ26='',CALTIME='20221124',UPDATED_TIMESTAMP='2022/11/25 7:41:23',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221124','数据爬取','85.484999','','布伦特现货','20221124','','','','','mail','85.485','2022','','ZBCRD0020DD','布伦特 现货（日）','灵活查询','数据爬取','202247','','美元/桶','D','','CRD','9999','布伦特现货','Y','0','2022-Q4','','D','','','','99991231','油价快报导入指标','','20221124','2022/11/25 7:41:23','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBCRD0004AD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221124' as CALDAY,'办公厅获取的沪原油价格' as ZBSMXX,'590.2' as VALUE1_SUM,'' as SJZT,'沪原油' as ZBSDLTXT,'20221124' as SDATE,'' as ZBHQDZ,'' as BZ,'202211' as CALJJQ27,'' as ZBBZ,'sjcj' as UPDATED_USER,'590.2' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBCRD0004AD' as ZBBM,'沪原油（日）' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'办公厅获取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'元' as ZBDW,'D' as ZBSJLX,'202211' as CALJJQ28,'CRD' as ZBLX,'9999' as ZBSORDER1,'沪原油' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'202211' as CALJJQ25,'A' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'' as ZBLXMS,'202211' as CALJJQ26,'20221124' as CALTIME,'2022/11/25 8:00:43' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221124',ZBSMXX='办公厅获取的沪原油价格',VALUE1_SUM='590.2',SJZT='',ZBSDLTXT='沪原油',SDATE='20221124',ZBHQDZ='',BZ='',CALJJQ27='202211',ZBBZ='',UPDATED_USER='sjcj',VALUE1='590.2',CALYEAR='2022',ZBLYMS='',ZBBM='ZBCRD0004AD',ZBCXGJC='沪原油（日）',ZBLHCXBS='灵活查询',ZBHQFSMS='办公厅获取',CALWEEK='202247',TVALUE2='',ZBDW='元',ZBSJLX='D',CALJJQ28='202211',ZBLX='CRD',ZBSORDER1='9999',ZBMS='沪原油',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='202211',ZBHQFS='A',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='',CALJJQ26='202211',CALTIME='20221124',UPDATED_TIMESTAMP='2022/11/25 8:00:43',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221124','办公厅获取的沪原油价格','590.2','','沪原油','20221124','','','202211','','sjcj','590.2','2022','','ZBCRD0004AD','沪原油（日）','灵活查询','办公厅获取','202247','','元','D','202211','CRD','9999','沪原油','Y','0','2022-Q4','202211','A','','','','99991231','','202211','20221124','2022/11/25 8:00:43','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBCRD0001DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221124' as CALDAY,'华尔街见闻爬取的布伦特期货日均价格' as ZBSMXX,'85.12' as VALUE1_SUM,'' as SJZT,'布伦特期货' as ZBSDLTXT,'20221124' as SDATE,'https://wallstreetcn.com/markets/commodities/UKOIL' as ZBHQDZ,'' as BZ,'202211' as CALJJQ27,'' as ZBBZ,'mail' as UPDATED_USER,'85.12' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBCRD0001DD' as ZBBM,'布伦特期货（日）' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'美元/桶' as ZBDW,'D' as ZBSJLX,'202211' as CALJJQ28,'CRD' as ZBLX,'2' as ZBSORDER1,'布伦特期货' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'202211' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'油价快报导入指标' as ZBLXMS,'202211' as CALJJQ26,'20221124' as CALTIME,'2022/11/25 7:41:23' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221124',ZBSMXX='华尔街见闻爬取的布伦特期货日均价格',VALUE1_SUM='85.12',SJZT='',ZBSDLTXT='布伦特期货',SDATE='20221124',ZBHQDZ='https://wallstreetcn.com/markets/commodities/UKOIL',BZ='',CALJJQ27='202211',ZBBZ='',UPDATED_USER='mail',VALUE1='85.12',CALYEAR='2022',ZBLYMS='',ZBBM='ZBCRD0001DD',ZBCXGJC='布伦特期货（日）',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='美元/桶',ZBSJLX='D',CALJJQ28='202211',ZBLX='CRD',ZBSORDER1='2',ZBMS='布伦特期货',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='202211',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='油价快报导入指标',CALJJQ26='202211',CALTIME='20221124',UPDATED_TIMESTAMP='2022/11/25 7:41:23',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221124','华尔街见闻爬取的布伦特期货日均价格','85.12','','布伦特期货','20221124','https://wallstreetcn.com/markets/commodities/UKOIL','','202211','','mail','85.12','2022','','ZBCRD0001DD','布伦特期货（日）','灵活查询','数据爬取','202247','','美元/桶','D','202211','CRD','2','布伦特期货','Y','0','2022-Q4','202211','D','','','','99991231','油价快报导入指标','202211','20221124','2022/11/25 7:41:23','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBCRD0003AD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221124' as CALDAY,'办公厅获取的迪拜日均价格' as ZBSMXX,'77.64' as VALUE1_SUM,'' as SJZT,'迪拜现货' as ZBSDLTXT,'20221124' as SDATE,'' as ZBHQDZ,'' as BZ,'202211' as CALJJQ27,'' as ZBBZ,'mail' as UPDATED_USER,'77.64' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBCRD0003AD' as ZBBM,'互供计价期迪拜原油价格' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'办公厅获取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'美元/桶' as ZBDW,'D' as ZBSJLX,'202211' as CALJJQ28,'CRD' as ZBLX,'4' as ZBSORDER1,'迪拜现货' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'202211' as CALJJQ25,'A' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'油价快报导入指标' as ZBLXMS,'202211' as CALJJQ26,'20221124' as CALTIME,'2022/11/25 7:41:23' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221124',ZBSMXX='办公厅获取的迪拜日均价格',VALUE1_SUM='77.64',SJZT='',ZBSDLTXT='迪拜现货',SDATE='20221124',ZBHQDZ='',BZ='',CALJJQ27='202211',ZBBZ='',UPDATED_USER='mail',VALUE1='77.64',CALYEAR='2022',ZBLYMS='',ZBBM='ZBCRD0003AD',ZBCXGJC='互供计价期迪拜原油价格',ZBLHCXBS='灵活查询',ZBHQFSMS='办公厅获取',CALWEEK='202247',TVALUE2='',ZBDW='美元/桶',ZBSJLX='D',CALJJQ28='202211',ZBLX='CRD',ZBSORDER1='4',ZBMS='迪拜现货',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='202211',ZBHQFS='A',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='油价快报导入指标',CALJJQ26='202211',CALTIME='20221124',UPDATED_TIMESTAMP='2022/11/25 7:41:23',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221124','办公厅获取的迪拜日均价格','77.64','','迪拜现货','20221124','','','202211','','mail','77.64','2022','','ZBCRD0003AD','互供计价期迪拜原油价格','灵活查询','办公厅获取','202247','','美元/桶','D','202211','CRD','4','迪拜现货','Y','0','2022-Q4','202211','A','','','','99991231','油价快报导入指标','202211','20221124','2022/11/25 7:41:23','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBSTK0017DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221124' as CALDAY,'外汇管理局爬取的美元汇率' as ZBSMXX,'712.009999' as VALUE1_SUM,'' as SJZT,'美元中间价' as ZBSDLTXT,'20221124' as SDATE,'http://www.safe.gov.cn/AppStructured/view/project_RMBQuery.action' as ZBHQDZ,'' as BZ,'202211' as CALJJQ27,'' as ZBBZ,'sjcj' as UPDATED_USER,'712.01' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBSTK0017DD' as ZBBM,'美元汇率中间价' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'百美元人民币' as ZBDW,'D' as ZBSJLX,'202211' as CALJJQ28,'STK' as ZBLX,'9999' as ZBSORDER1,'美元中间价' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'202211' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'汇率' as ZBLXMS,'202211' as CALJJQ26,'20221124' as CALTIME,'2022/11/25 9:00:24' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221124',ZBSMXX='外汇管理局爬取的美元汇率',VALUE1_SUM='712.009999',SJZT='',ZBSDLTXT='美元中间价',SDATE='20221124',ZBHQDZ='http://www.safe.gov.cn/AppStructured/view/project_RMBQuery.action',BZ='',CALJJQ27='202211',ZBBZ='',UPDATED_USER='sjcj',VALUE1='712.01',CALYEAR='2022',ZBLYMS='',ZBBM='ZBSTK0017DD',ZBCXGJC='美元汇率中间价',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='百美元人民币',ZBSJLX='D',CALJJQ28='202211',ZBLX='STK',ZBSORDER1='9999',ZBMS='美元中间价',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='202211',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='汇率',CALJJQ26='202211',CALTIME='20221124',UPDATED_TIMESTAMP='2022/11/25 9:00:24',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221124','外汇管理局爬取的美元汇率','712.009999','','美元中间价','20221124','http://www.safe.gov.cn/AppStructured/view/project_RMBQuery.action','','202211','','sjcj','712.01','2022','','ZBSTK0017DD','美元汇率中间价','灵活查询','数据爬取','202247','','百美元人民币','D','202211','STK','9999','美元中间价','Y','0','2022-Q4','202211','D','','','','99991231','汇率','202211','20221124','2022/11/25 9:00:24','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBSTK0017DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221125' as CALDAY,'外汇管理局爬取的美元汇率' as ZBSMXX,'713.389999' as VALUE1_SUM,'' as SJZT,'美元中间价' as ZBSDLTXT,'20221125' as SDATE,'http://www.safe.gov.cn/AppStructured/view/project_RMBQuery.action' as ZBHQDZ,'' as BZ,'202211' as CALJJQ27,'' as ZBBZ,'sjcj' as UPDATED_USER,'713.39' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBSTK0017DD' as ZBBM,'美元汇率中间价' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'百美元人民币' as ZBDW,'D' as ZBSJLX,'202211' as CALJJQ28,'STK' as ZBLX,'9999' as ZBSORDER1,'美元中间价' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'202212' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'汇率' as ZBLXMS,'202211' as CALJJQ26,'20221125' as CALTIME,'2022/11/25 15:00:09' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221125',ZBSMXX='外汇管理局爬取的美元汇率',VALUE1_SUM='713.389999',SJZT='',ZBSDLTXT='美元中间价',SDATE='20221125',ZBHQDZ='http://www.safe.gov.cn/AppStructured/view/project_RMBQuery.action',BZ='',CALJJQ27='202211',ZBBZ='',UPDATED_USER='sjcj',VALUE1='713.39',CALYEAR='2022',ZBLYMS='',ZBBM='ZBSTK0017DD',ZBCXGJC='美元汇率中间价',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='百美元人民币',ZBSJLX='D',CALJJQ28='202211',ZBLX='STK',ZBSORDER1='9999',ZBMS='美元中间价',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='202212',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='汇率',CALJJQ26='202211',CALTIME='20221125',UPDATED_TIMESTAMP='2022/11/25 15:00:09',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221125','外汇管理局爬取的美元汇率','713.389999','','美元中间价','20221125','http://www.safe.gov.cn/AppStructured/view/project_RMBQuery.action','','202211','','sjcj','713.39','2022','','ZBSTK0017DD','美元汇率中间价','灵活查询','数据爬取','202247','','百美元人民币','D','202211','STK','9999','美元中间价','Y','0','2022-Q4','202212','D','','','','99991231','汇率','202211','20221125','2022/11/25 15:00:09','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBSTK0042DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221124' as CALDAY,'中国石化内部财务网站http://oas.sfc.sinopec.com/' as ZBSMXX,'7.1424' as VALUE1_SUM,'' as SJZT,'美元结汇价' as ZBSDLTXT,'20221124' as SDATE,'http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734' as ZBHQDZ,'' as BZ,'' as CALJJQ27,'' as ZBBZ,'sjcj' as UPDATED_USER,'7.1424' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBSTK0042DD' as ZBBM,'美元汇率结汇价' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'美元RMB' as ZBDW,'D' as ZBSJLX,'' as CALJJQ28,'STK' as ZBLX,'9999' as ZBSORDER1,'美元结汇价' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'汇率' as ZBLXMS,'' as CALJJQ26,'20221124' as CALTIME,'2022/11/25 10:00:09' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221124',ZBSMXX='中国石化内部财务网站http://oas.sfc.sinopec.com/',VALUE1_SUM='7.1424',SJZT='',ZBSDLTXT='美元结汇价',SDATE='20221124',ZBHQDZ='http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734',BZ='',CALJJQ27='',ZBBZ='',UPDATED_USER='sjcj',VALUE1='7.1424',CALYEAR='2022',ZBLYMS='',ZBBM='ZBSTK0042DD',ZBCXGJC='美元汇率结汇价',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='美元RMB',ZBSJLX='D',CALJJQ28='',ZBLX='STK',ZBSORDER1='9999',ZBMS='美元结汇价',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='汇率',CALJJQ26='',CALTIME='20221124',UPDATED_TIMESTAMP='2022/11/25 10:00:09',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221124','中国石化内部财务网站http://oas.sfc.sinopec.com/','7.1424','','美元结汇价','20221124','http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734','','','','sjcj','7.1424','2022','','ZBSTK0042DD','美元汇率结汇价','灵活查询','数据爬取','202247','','美元RMB','D','','STK','9999','美元结汇价','Y','0','2022-Q4','','D','','','','99991231','汇率','','20221124','2022/11/25 10:00:09','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBSTK0042DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221125' as CALDAY,'中国石化内部财务网站http://oas.sfc.sinopec.com/' as ZBSMXX,'7.1398' as VALUE1_SUM,'' as SJZT,'美元结汇价' as ZBSDLTXT,'20221125' as SDATE,'http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734' as ZBHQDZ,'' as BZ,'' as CALJJQ27,'' as ZBBZ,'sjcj' as UPDATED_USER,'7.1398' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBSTK0042DD' as ZBBM,'美元汇率结汇价' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'美元RMB' as ZBDW,'D' as ZBSJLX,'' as CALJJQ28,'STK' as ZBLX,'9999' as ZBSORDER1,'美元结汇价' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'汇率' as ZBLXMS,'' as CALJJQ26,'20221125' as CALTIME,'2022/11/25 10:00:09' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221125',ZBSMXX='中国石化内部财务网站http://oas.sfc.sinopec.com/',VALUE1_SUM='7.1398',SJZT='',ZBSDLTXT='美元结汇价',SDATE='20221125',ZBHQDZ='http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734',BZ='',CALJJQ27='',ZBBZ='',UPDATED_USER='sjcj',VALUE1='7.1398',CALYEAR='2022',ZBLYMS='',ZBBM='ZBSTK0042DD',ZBCXGJC='美元汇率结汇价',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='美元RMB',ZBSJLX='D',CALJJQ28='',ZBLX='STK',ZBSORDER1='9999',ZBMS='美元结汇价',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='汇率',CALJJQ26='',CALTIME='20221125',UPDATED_TIMESTAMP='2022/11/25 10:00:09',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221125','中国石化内部财务网站http://oas.sfc.sinopec.com/','7.1398','','美元结汇价','20221125','http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734','','','','sjcj','7.1398','2022','','ZBSTK0042DD','美元汇率结汇价','灵活查询','数据爬取','202247','','美元RMB','D','','STK','9999','美元结汇价','Y','0','2022-Q4','','D','','','','99991231','汇率','','20221125','2022/11/25 10:00:09','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBSTK0043DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221124' as CALDAY,'中国石化内部财务网站http://oas.sfc.sinopec.com/' as ZBSMXX,'7.157499' as VALUE1_SUM,'' as SJZT,'美元售汇价' as ZBSDLTXT,'20221124' as SDATE,'http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734' as ZBHQDZ,'' as BZ,'' as CALJJQ27,'' as ZBBZ,'sjcj' as UPDATED_USER,'7.1575' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBSTK0043DD' as ZBBM,'美元汇率售汇价' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'美元RMB' as ZBDW,'D' as ZBSJLX,'' as CALJJQ28,'STK' as ZBLX,'9999' as ZBSORDER1,'美元售汇价' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'汇率' as ZBLXMS,'' as CALJJQ26,'20221124' as CALTIME,'2022/11/25 10:00:09' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221124',ZBSMXX='中国石化内部财务网站http://oas.sfc.sinopec.com/',VALUE1_SUM='7.157499',SJZT='',ZBSDLTXT='美元售汇价',SDATE='20221124',ZBHQDZ='http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734',BZ='',CALJJQ27='',ZBBZ='',UPDATED_USER='sjcj',VALUE1='7.1575',CALYEAR='2022',ZBLYMS='',ZBBM='ZBSTK0043DD',ZBCXGJC='美元汇率售汇价',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='美元RMB',ZBSJLX='D',CALJJQ28='',ZBLX='STK',ZBSORDER1='9999',ZBMS='美元售汇价',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='汇率',CALJJQ26='',CALTIME='20221124',UPDATED_TIMESTAMP='2022/11/25 10:00:09',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221124','中国石化内部财务网站http://oas.sfc.sinopec.com/','7.157499','','美元售汇价','20221124','http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734','','','','sjcj','7.1575','2022','','ZBSTK0043DD','美元汇率售汇价','灵活查询','数据爬取','202247','','美元RMB','D','','STK','9999','美元售汇价','Y','0','2022-Q4','','D','','','','99991231','汇率','','20221124','2022/11/25 10:00:09','');MERGE INTO R2_CWSJ00 a USING(SELECT 'ZBBM' as ZBSTK0043DD,'202211' as CALMONTH,'' as TVALUE1,'' as ZBSJZFL1,'' as ZBSCPFL,'20221125' as CALDAY,'中国石化内部财务网站http://oas.sfc.sinopec.com/' as ZBSMXX,'7.154899' as VALUE1_SUM,'' as SJZT,'美元售汇价' as ZBSDLTXT,'20221125' as SDATE,'http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734' as ZBHQDZ,'' as BZ,'' as CALJJQ27,'' as ZBBZ,'sjcj' as UPDATED_USER,'7.1549' as VALUE1,'2022' as CALYEAR,'' as ZBLYMS,'ZBSTK0043DD' as ZBBM,'美元汇率售汇价' as ZBCXGJC,'灵活查询' as ZBLHCXBS,'数据爬取' as ZBHQFSMS,'202247' as CALWEEK,'' as TVALUE2,'美元RMB' as ZBDW,'D' as ZBSJLX,'' as CALJJQ28,'STK' as ZBLX,'9999' as ZBSORDER1,'美元售汇价' as ZBMS,'Y' as INUSE,'0' as VALUE2,'2022-Q4' as CALQUART,'' as CALJJQ25,'D' as ZBHQFS,'' as ZBSJZFL,'' as ZBLY,'' as ZBSTRQFL,'99991231' as EDATE,'汇率' as ZBLXMS,'' as CALJJQ26,'20221125' as CALTIME,'2022/11/25 10:00:09' as UPDATED_TIMESTAMP,'' as SCZT FROM dual) b ON (a.ZBBM=b.ZBBM) WHEN MATCHED THEN UPDATE SET UPDATE_ODS_TIME = TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),CALMONTH='202211',TVALUE1='',ZBSJZFL1='',ZBSCPFL='',CALDAY='20221125',ZBSMXX='中国石化内部财务网站http://oas.sfc.sinopec.com/',VALUE1_SUM='7.154899',SJZT='',ZBSDLTXT='美元售汇价',SDATE='20221125',ZBHQDZ='http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734',BZ='',CALJJQ27='',ZBBZ='',UPDATED_USER='sjcj',VALUE1='7.1549',CALYEAR='2022',ZBLYMS='',ZBBM='ZBSTK0043DD',ZBCXGJC='美元汇率售汇价',ZBLHCXBS='灵活查询',ZBHQFSMS='数据爬取',CALWEEK='202247',TVALUE2='',ZBDW='美元RMB',ZBSJLX='D',CALJJQ28='',ZBLX='STK',ZBSORDER1='9999',ZBMS='美元售汇价',INUSE='Y',VALUE2='0',CALQUART='2022-Q4',CALJJQ25='',ZBHQFS='D',ZBSJZFL='',ZBLY='',ZBSTRQFL='',EDATE='99991231',ZBLXMS='汇率',CALJJQ26='',CALTIME='20221125',UPDATED_TIMESTAMP='2022/11/25 10:00:09',SCZT='' WHEN NOT MATCHED THEN INSERT  (INSERT_ODS_TIME,'CALMONTH','TVALUE1','ZBSJZFL1','ZBSCPFL','CALDAY','ZBSMXX','VALUE1_SUM','SJZT','ZBSDLTXT','SDATE','ZBHQDZ','BZ','CALJJQ27','ZBBZ','UPDATED_USER','VALUE1','CALYEAR','ZBLYMS','ZBBM','ZBCXGJC','ZBLHCXBS','ZBHQFSMS','CALWEEK','TVALUE2','ZBDW','ZBSJLX','CALJJQ28','ZBLX','ZBSORDER1','ZBMS','INUSE','VALUE2','CALQUART','CALJJQ25','ZBHQFS','ZBSJZFL','ZBLY','ZBSTRQFL','EDATE','ZBLXMS','CALJJQ26','CALTIME','UPDATED_TIMESTAMP','SCZT') VALUES (TO_DATE('2022-11-25 21:37:51', 'YYYY-MM-DD HH24:MI:SS'),'202211','','','','20221125','中国石化内部财务网站http://oas.sfc.sinopec.com/','7.154899','','美元售汇价','20221125','http://10.5.58.64:8088/HLAjax.aspx?callback=jQuery1124012862585068529886_1550472042732&action=hl&date=2019-02-15&type=RMB_USD_%E7%BE%8E%E5%85%83&_=1550472042734','','','','sjcj','7.1549','2022','','ZBSTK0043DD','美元汇率售汇价','灵活查询','数据爬取','202247','','美元RMB','D','','STK','9999','美元售汇价','Y','0','2022-Q4','','D','','','','99991231','汇率','','20221125','2022/11/25 10:00:09','');select 1 into n  from dual;end;

select OWNER,TABLE_NAME TABLE_LOG_NAME,REPLACE(TABLE_NAME, 'MLOG$_', '') TABLE_NAME from all_tables WHERE 
1=1
and OWNER='RAW_DZJLD' -- //这里是各数据库的用户名  需要调整
and LOGGING='YES';