oracle 更新 递归数据 如何实现
update (select *
from hndprjriskconfig
start with configno = '10142'
connect by prior configno = upconfigno)
set remark1 = ''
where rownum =1
如上所示, 我想要更新
select *
from hndprjriskconfig
start with configno = '10142'
connect by prior configno = upconfigno
这一批数据,将remark1字段指定值,该如何实现呢
PS:如上sql直接执行是报错的。