update table1 set col1=(select col2 from table2 where table1.pk=table2.pk)
where exists(select col2 from table2 where table1.pk=table2.pk);
where exists(select col2 from table2 where table1.pk=table2.pk);
解决方案 »
- sql 转到 oracle
- 两个结果集相互查询
- oralce排序问题
- select count(*) as temp from pre_house where recnum not in (select distinct max(t1.recnum) from pre_house t1 group by t1.righ
- sql语句询问
- 如何更改apps和applsys密码呀?
- 从Windows 2000 server 连接 oracle 数据库的问题??
- 紧急求救:ORACLE中sql语句如mydate between '2002-01-01' and '2002-05-01'如何表示?(
- 急!在线等!!!存储过程
- 用pl\sql developer 导入dmp表报错
- 各位大侠:帮忙解决一个问题
- 序列自动递增!
按照你的方法,它报的是这个错。
where exists(select col2 from table2 where table1.pk=table2.pk);