SQL Server 转换为 Oracle 数据库遇到的一个SQL特例

来源：互联网发布：mac系统强制关闭程序编辑：程序博客网时间：2024/06/05 12:40

SQL Server 转换为 Oracle 数据库遇到的一个SQL特例
记录下来，共以后参考

相关表联合条件删除某一个表的数据时，一下的SQL语句 SQL server 可以执行Oracle不可以执行：

delete RF_SURVEY_RESULT_DETAIL from RF_SURVEY_RESULT_DETAIL
inner join RF_SURVEY_OBJECT_RELATE on RF_SURVEY_RESULT_DETAIL.IN_SURVEY_OBJECT_ID = RF_SURVEY_OBJECT_RELATE.IN_SURVEY_OBJECT_ID
where RF_SURVEY_RESULT_DETAIL.IN_SURVEY_ID=77
and RF_SURVEY_RESULT_DETAIL.IN_SURVEY_SUBJECT_ID=1
and RF_SURVEY_OBJECT_RELATE.IN_SURVEY_OBJECT_GROUP_ID =29

--以下Oracle可以执行
delete from RF_SURVEY_RESULT_DETAIL
where RF_SURVEY_RESULT_DETAIL.IN_SURVEY_ID=770
and RF_SURVEY_RESULT_DETAIL.IN_SURVEY_SUBJECT_ID=10
and RF_SURVEY_RESULT_DETAIL.IN_SURVEY_OBJECT_ID in (select IN_SURVEY_OBJECT_ID from RF_SURVEY_OBJECT_RELATE where IN_SURVEY_OBJECT_GROUP_ID =29 )