UPDATE记录（如果存在）;否则在Oracle中插入
是否有任何Oracle函数指示是否存在记录或任何其他有用的技术来实现此目的？
编辑：使用我做的MERGE语句：
MERGE
INTO lims_min.mytab src
USING lims_min.mytab tgt
ON ( src.col1 = tgt.col1
AND tgt.col1 = p_val1
AND src.col2 = tgt.col2
AND tgt.col2 = p_val2
)
WHEN MATCHED
THEN
UPDATE
SET tgt.col3=p_val3,
tgt.col4=p_val4
WHEN NOT MATCHED
THEN
INSERT (col1, col2, col3, col4)
VALUES (val1, val2, val2, val4);
没有找到相关结果
已邀请:
2 个回复
俺呵誓放胳
。MERGE INTO target_table tgt USING source_table src ON ( src.object_id = tgt.object_id ) //The key to check if the record exists WHEN MATCHED // if exists THEN UPDATE SET tgt.object_name = src.object_name //update it , tgt.object_type = src.object_type WHEN NOT MATCHED // if not exists THEN INSERT ( tgt.object_id //then insert , tgt.object_name , tgt.object_type ) VALUES ( src.object_id , src.object_name , src.object_type );魄龟呸筹