delete from a where exists(select 1 from b where a.col=b.col and ...);
delete from b where exists(select 1 from a where a.col=b.col and ...);
delete from b where exists(select 1 from a where a.col=b.col and ...);
解决方案 »
- oracle 存储过程编译报错!请各位高数帮忙看看,小弟在线等待...
- oracle11g如何用IE登录sqlplus
- oracle 访问sql server
- Oracle的计划任务?急!急!
- SQL Server 安装问题
- Toad連接Oracle會出現“ORA-12154: TNS:無法決定服務名稱”的錯誤
- oralce登陆问题
- 一个Oracle中时间问题
- 急!急!急!delphi 6 通过 odbc 访问 oracle 7 出现问题?
- 求一条sql语句,两条数据合并为一条结果集显示??
- 请教:UNION ALL的用法???
- 紧急求救!!连接oracle出了这样的错误java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
delete from b where exists(select 1 from a where a.col=b.col and ...);
delete from a where exists(select 1 from tbt where tbt.col=a.col and ...);
delete from b where exists(select 1 from tbt where tbt.col=b.col and ...);
drop table tbt;