UPDATE W_AR_XACT_F F
SET F.COST_CENTER_WID = tb.ROW_WID
FROM
(SELECT D.ROW_WID, FS.INTEGRATION_ID
FROM W_AR_XACT_FS FS, W_COST_CENTER_D D
WHERE D.INTEGRATION_ID =FS.COST_CENTER_ID) tb
WHERE F.DATASOURCE_NUM_ID = 32
AND F.INTEGRATION_ID = tb.INTEGRATION_ID;
这是我的语句,怎么提醒00933. 00000 - "SQL command not properly ended"错误,谢谢帮忙了
SET F.COST_CENTER_WID = tb.ROW_WID
FROM
(SELECT D.ROW_WID, FS.INTEGRATION_ID
FROM W_AR_XACT_FS FS, W_COST_CENTER_D D
WHERE D.INTEGRATION_ID =FS.COST_CENTER_ID) tb
WHERE F.DATASOURCE_NUM_ID = 32
AND F.INTEGRATION_ID = tb.INTEGRATION_ID;
这是我的语句,怎么提醒00933. 00000 - "SQL command not properly ended"错误,谢谢帮忙了
解决方案 »
- 提供者就给分 ,虽然不多.
- 请问在ORACLE中日期怎样输入?
- oracle中decode()函数在mysql中怎么改啊,在线等!
- 求sql语句(在线等)
- 急 -- php连接Oracle数据库经常连接失败
- oracle中的存储过程与proc
- ◆◆如何删除一个字段?◆◆
- SQL基础问题,四个sql语句的效率有什么区别?
- 关于大数据量的查询问题,我用了两个WHILE,但发觉速度为什么这么慢,请有经验的人来评评(在线等待)
- java.sql.SQLException: Io 异常: The Network Adapter could not establish the connec
- 查询
- 如何用数组存数据
SET F.COST_CENTER_WID = select tb.ROW_WID FROM (SELECT D.ROW_WID,
FS.INTEGRATION_ID
FROM W_AR_XACT_FS FS,
W_COST_CENTER_D D
WHERE D.INTEGRATION_ID =
FS.COST_CENTER_ID) tb
WHERE F.DATASOURCE_NUM_ID = 32
AND F.INTEGRATION_ID = tb.INTEGRATION_ID;
你这样是错的,提示说select那里缺少表达式
SET F.COST_CENTER_WID = tb.ROW_WID
FROM
(SELECT D.ROW_WID, FS.INTEGRATION_ID
FROM W_AR_XACT_FS FS, W_COST_CENTER_D D
WHERE D.INTEGRATION_ID =FS.COST_CENTER_ID) tb, W_AR_XACT_F F
WHERE F.INTEGRATION_ID = tb.INTEGRATION_ID
and F.DATASOURCE_NUM_ID = 32;
set f.cost_center_wid = (
select d.row_wid from (
select d.row_wid,fs.integration_id
from w_cost_center_d d,
w_ar_xact_fs fs
where d.integration_id = fs.cost_center_id) tb
where f.datasource_num_id = 32
and f.integration_id = tb.integration_id
)
UPDATE (SELECT /*+ BYPASS_UJVC */ F.COST_CENTER_WID, tb.ROW_WID
FROM (SELECT D.ROW_WID, FS.INTEGRATION_ID
FROM W_AR_XACT_FS FS, W_COST_CENTER_D D
WHERE D.INTEGRATION_ID =FS.COST_CENTER_ID) tb,
W_AR_XACT_F F
WHERE F.DATASOURCE_NUM_ID = 32
AND F.INTEGRATION_ID = tb.INTEGRATION_ID)
SET COST_CENTER_WID = ROW_WID
SET F.COST_CENTER_WID =
(SELECT D.ROW_WID
FROM W_AR_XACT_FS FS, W_COST_CENTER_D D
WHERE D.INTEGRATION_ID = FS.COST_CENTER_ID
and FS.INTEGRATION_ID = F.INTEGRATION_ID)
WHERE F.DATASOURCE_NUM_ID = 32;
SET F.COST_CENTER_WID = (select tb.ROW_WID
FROM
(SELECT D.ROW_WID, FS.INTEGRATION_ID
FROM W_AR_XACT_FS FS, W_COST_CENTER_D D
WHERE D.INTEGRATION_ID =FS.COST_CENTER_ID) tb where F.DATASOURCE_NUM_ID = 32
AND F.INTEGRATION_ID = tb.INTEGRATION_ID )
WHERE F.DATASOURCE_NUM_ID = 32
AND F.INTEGRATION_ID = (select tb.INTEGRATION_ID
FROM
(SELECT D.ROW_WID, FS.INTEGRATION_ID
FROM W_AR_XACT_FS FS, W_COST_CENTER_D D
WHERE D.INTEGRATION_ID =FS.COST_CENTER_ID) tb where F.DATASOURCE_NUM_ID = 32
AND F.INTEGRATION_ID = tb.INTEGRATION_ID );