oracle01733,database - Oracle Update Query on Select Query |错误ORA-01733此处不允许使用虚拟列 - SO中文参考 - www.soi...

Oracle Update Query on Select Query |错误ORA-01733此处不允许使用虚拟列

问题描述 投票：2回答：1

update(

select id, word, status

case when sm = 1 and status = 'Renew'

then coalesce(lgst, 'Add')

else status

end as status1,

timestamp,

clob_column

from

(select id, word, status,

sum(case when status = 'Renew' then 1 else 0 end) over (partition by id order by timestamp) as sm,

lag(status) over (partition by id order by timestamp) as lgst, timestamp, clob_column

from your_table)_

set clob_column = REPLACE( clob_column , '"key":'||status, '"key":'||status1);

在上述查询中运行时出现错误set clob_column = REPLACE(clob_column，'“ key”：'||状态，'“ key”：'|| status1)命令行错误：26列：7错误报告：SQL错误：ORA-01733：此