udpate books
set pubid =
(
select b.pubid
from publish b
where a.isdn = b.isdn
)
set pubid =
(
select b.pubid
from publish b
where a.isdn = b.isdn
)
解决方案 »
- 如何查谁执行了此sql
- 从oracle中取出的字段后有空格!!
- to_char的用法 急救!!
- 触发器中是不是可以定义变量,我这个触发器有什么错,请高手指教!!!
- 求一个貌似简单但一时想不出来怎么写的delete语句???
- redhat as 4下安装oracle 9i
- 100分求助简单问题:Oracle安装时将NTS改为None对Oracle有什么影响?
- powerdesign里如何添加数据
- Oracle9i中有无和MS SQL Profiler(SQL事件探查器)对应的SQL监视工具?
- 请教:用PL/SQL Develop工具从Excel中导入数据记录到Oracle9i下出错(ORA-00928)
- ▲oracel的 case.. when 语句在ADO中出错!▲
- 请教一个转帐的存储过程
udpate books a
set pubid =
(
select b.pubid
from publish b
where a.isdn = b.isdn
)
set a.pubid=b.pubid
where exists (select 1 from publish b
where a.isdn=b.isdn);
set pubid =
(
select MAX(b.pubid)
from publish b
where a.isdn = b.isdn
)
where exists(select 1 from publish b where a.isdn = b.isdn);
set a.pubid=(select pubid from publish where isdn=a.isdn)
where exists (select 1 from publish b
where a.isdn=b.isdn);