17,377
社区成员
发帖
与我相关
我的任务
分享这个语句oracle怎么写？
sqlserver语法
update tablea set tablea_column=tablea_column-tableb_column from tableb where tablea_id=tableb_id
请问oracle语法怎么写？
update tablea set tablea_column=tablea_column-tableb_column from tableb where tablea_id=tableb_id
请问oracle语法怎么写？
...全文
请发表友善的回复…
发表回复
zjkk1011 2008-03-07
- 打赏
- 举报
update tablea a
set tablea_column = tablea_column - (select tableb_column from tableb
where a.tablea_id=tableb_id)
where exists (select null from tableb
where a.tablea_id = tableb_id)
set tablea_column = tablea_column - (select tableb_column from tableb
where a.tablea_id=tableb_id)
where exists (select null from tableb
where a.tablea_id = tableb_id)
tanjun132 2008-03-06
- 打赏
- 举报
update table a
set table a_column = (select a.tablea_column-b.tableb_column fromm tableb b where tablea_id=b.tableb_id )
就OK拉
set table a_column = (select a.tablea_column-b.tableb_column fromm tableb b where tablea_id=b.tableb_id )
就OK拉
ehsgs 2008-03-06
- 打赏
- 举报
update table a set tablea_column = (select a.tablea_column-b.tableb_column fromm tablea a,tableb b where a.tablea_id=b.tableb_id )
ehsgs 2008-03-06
- 打赏
- 举报
update table a set table a_col = (select tablea_column-tableb_column fromm tablea a,tableb b where a.tablea_id=b.tableb_id )
Anders_lt 2008-03-06
- 打赏
- 举报
ding
