在SQL中完成所有操作,而不是将上下文切换到PL / SQL:
INSERT INTO DATA1.FOLDERS(folder_id, user_id)SELECt f1.folder_id, f1.user_id FROM DATA1.FOLDERS f1 WHERe NOT EXISTS (SELECt 1 FROM DATA1.FOLDERS f2 WHERe f1.folder_id = f2.folder_idAND f1.user_id = f2.user_id);

在SQL中完成所有操作,而不是将上下文切换到PL / SQL:
INSERT INTO DATA1.FOLDERS(folder_id, user_id)SELECt f1.folder_id, f1.user_id FROM DATA1.FOLDERS f1 WHERe NOT EXISTS (SELECt 1 FROM DATA1.FOLDERS f2 WHERe f1.folder_id = f2.folder_idAND f1.user_id = f2.user_id);