Merge Into合并Oracle表数据

根据DER_DESIGN_NAME、DER_DESIGN_VERSION、PARTPN将bom_functiontemp表中的数据转移至bom_function表中

MERGE INTO bom_function bf USING bom_functiontemp bft ON (
bf.der_design_name = bft.der_design_name 
AND bf.der_design_version = bft.der_design_version 
AND bf.partpn = bft.partpn 
AND bf.instance_name = bft.instance_name 
) 
WHEN MATCHED THEN
UPDATE 
    SET bf.GMT_CREATED = bft.GMT_CREATED,
    bf.GMT_MODIFIED = bft.GMT_MODIFIED,
    bf.CIRCUIT_NO = bft.CIRCUIT_NO,
    bf.COMPOSITE_NAME = bft.COMPOSITE_NAME,
    bf.COMPOSITEPN = bft.COMPOSITEPN,
    bf.COMPOSITE_VERSION = bft.COMPOSITE_VERSION,
    bf.COST = bft.COST,
    bf.DER_DESIGN_LEVEL = bft.DER_DESIGN_LEVEL,
    bf.DER_HARNESSPN = bft.DER_HARNESSPN,
    bf.FUNCTION_CODE = bft.FUNCTION_CODE,
    bf.MC_TYPE_CODE = bft.MC_TYPE_CODE,
    bf.MULTICORE_NAME = bft.MULTICORE_NAME,
    bf.OPTION_CODE = bft.OPTION_CODE,
    bf.PROJECT_NAME = bft.PROJECT_NAME,
    bf.QUANTITY = bft.QUANTITY,
    bf.RELATED_CAVITY = bft.RELATED_CAVITY,
    bf.RELATED_CONN = bft.RELATED_CONN,
    bf.RELATED_WIRE = bft.RELATED_WIRE,
    bf.TWIST_RATE = bft.TWIST_RATE,
    bf.TYPE_CODE = bft.TYPE_CODE,
    bf.UNIT = bft.UNIT,
    bf.WEIGHT = bft.WEIGHT,
    bf.WIRE_COLOR = bft.WIRE_COLOR,
    bf.WIRE_CSA = bft.WIRE_CSA,
    bf.WIRE_DESCRIPTION = bft.WIRE_DESCRIPTION,
    bf.WIRE_FROM = bft.WIRE_FROM,
    bf.WIRE_FROM_CAVITY = bft.WIRE_FROM_CAVITY,
    bf.WIRE_MATERIAL_CODE = bft.WIRE_MATERIAL_CODE,
    bf.WIRE_TO = bft.WIRE_TO,
    bf.WIRE_TO_CAVITY = bft.WIRE_TO_CAVITY,
    bf.WIRE_USAGE = bft.WIRE_USAGE 
    WHEN NOT MATCHED THEN
    INSERT (
    bf.id,
    bf.GMT_CREATED,
    bf.GMT_MODIFIED,
    bf.CIRCUIT_NO,
    bf.COMPOSITE_NAME,
    bf.COMPOSITEPN,
    bf.COMPOSITE_VERSION,
    bf.COST,
    bf.DER_DESIGN_LEVEL,
    bf.DER_DESIGN_NAME,
    bf.DER_DESIGN_VERSION,
    bf.DER_HARNESSPN,
    bf.FUNCTION_CODE,
    bf.INSTANCE_NAME,
    bf.MC_TYPE_CODE,
    bf.MULTICORE_NAME,
    bf.OPTION_CODE,
    bf.PARTPN,
    bf.PROJECT_NAME,
    bf.QUANTITY,
    bf.RELATED_CAVITY,
    bf.RELATED_CONN,
    bf.RELATED_WIRE,
    bf.TWIST_RATE,
    bf.TYPE_CODE,
    bf.UNIT,
    bf.WEIGHT,
    bf.WIRE_COLOR,
    bf.WIRE_CSA,
    bf.WIRE_DESCRIPTION,
    bf.WIRE_FROM,
    bf.WIRE_FROM_CAVITY,
    bf.WIRE_MATERIAL_CODE,
    bf.WIRE_TO,
    bf.WIRE_TO_CAVITY,
    bf.WIRE_USAGE 
    )
VALUES
    (
    hibernate_sequence.nextval,
    bft.GMT_CREATED,
    bft.GMT_MODIFIED,
    bft.CIRCUIT_NO,
    bft.COMPOSITE_NAME,
    bft.COMPOSITEPN,
    bft.COMPOSITE_VERSION,
    bft.COST,
    bft.DER_DESIGN_LEVEL,
    bft.DER_DESIGN_NAME,
    bft.DER_DESIGN_VERSION,
    bft.DER_HARNESSPN,
    bft.FUNCTION_CODE,
    bft.INSTANCE_NAME,
    bft.MC_TYPE_CODE,
    bft.MULTICORE_NAME,
    bft.OPTION_CODE,
    bft.PARTPN,
    bft.PROJECT_NAME,
    bft.QUANTITY,
    bft.RELATED_CAVITY,
    bft.RELATED_CONN,
    bft.RELATED_WIRE,
    bft.TWIST_RATE,
    bft.TYPE_CODE,
    bft.UNIT,
    bft.WEIGHT,
    bft.WIRE_COLOR,
    bft.WIRE_CSA,
    bft.WIRE_DESCRIPTION,
    bft.WIRE_FROM,
    bft.WIRE_FROM_CAVITY,
    bft.WIRE_MATERIAL_CODE,
    bft.WIRE_TO,
    bft.WIRE_TO_CAVITY,
    bft.WIRE_USAGE)