存储过程

create or replace procedure Insert_To_BASE as
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;

==============