语法不对!
delete a where a.field = b.field1;
delete a where a.field = b.field1;
解决方案 »
- 关于win2008 server的ODBC设置
- 为什么在DOS上连接得上数据库,在oracle自带的sql*plus连接不上总是出现ora-12154问题,希望哪位可以解答,谢谢!
- oracle Rman 异机数据备份和恢复问题???
- ubuntu 下安装oracle10g后如何导入dmp文件?
- 插入后update与将字段计算出来后插入哪个快一些啊?大家讨论一下
- ORACLE:INVALID_HANDLE 什么错误??
- 谁有关于ORACLE的存储过程的电子教程
- ORACLE8I启动表分区功能需要什么包?
- 请教各位大侠们一个SQL
- 关于在ORACLE8I数据库中存储图片的问题(在线等待)
- 是否有关于Oracle异常处理中的RollBack的相关文档?谢谢
- 安装oracle8i的企业管理器时报错:ora-12224:tns:没有监听器
where a.field in (select b.field1 from b)
delete a
where a.field1 in (select b.field1 from b
where a.field1=b.field1 AND a.field2=b.field2 )
AND a.field2 in (select b.field1 from b
where a.field1=b.field1 AND a.field2=b.field2 )
delete a
where a.field1 in (select b.field1 from b
where a.field1=b.field1 AND a.field2=b.field2 )
AND a.field2 in (select b.field2 from b
where a.field1=b.field1 AND a.field2=b.field2 )
delete a
where a.field1 in (select b.field1 from b
where a.field1=b.field1 AND a.field2=b.field2 )