begin
insert into ODC_BASE_CONNECTIVITY ( RDFID,CONNECTIVITY_NMAE,RESOURCE_ID,SOURCE_CODE,DATA_SOURCE_ID,STATE)
select RDFID,CONNECTIVITY_NMAE,RESOURCE_ID,SOURCE_CODE,DATA_SOURCE_ID ,2 from ODC_TMP_CONNECTIVITY tmp
where not exists( select 1 from ODC_BASE_CONNECTIVITY base where base.rdfid = tmp.rdfid );
commit;
end ;
===========、
CREATE OR REPLACE PROCEDURE Update_TO_BASE AS
BEGIN
------------------------------- CONNECTIVITY
MERGE INTO ODC_BASE_CONNECTIVITY base
USING ODC_TMP_CONNECTIVITY tmp
ON ( base.RDFID = tmp.RDFID AND
(
base.CONNECTIVITY_NMAE <> tmp.CONNECTIVITY_NMAE OR
base.RESOURCE_ID <> tmp.RESOURCE_ID OR
base.SOURCE_CODE <> tmp.SOURCE_CODE OR
base.DATA_SOURCE_ID <> tmp.DATA_SOURCE_ID
)
)
WHEN MATCHED THEN
UPDATE
SET base.CONNECTIVITY_NMAE= tmp.CONNECTIVITY_NMAE ,
base.RESOURCE_ID = tmp.RESOURCE_ID ,
base.SOURCE_CODE = tmp.SOURCE_CODE ,
base.DATA_SOURCE_ID = tmp.DATA_SOURCE_ID ,
base.STATE = 3;
commit;
END;
==============