update (
select id
from tq84_A
)
set id = 1000 + id
where
rownum <= 5;
-- --: ORA-01732: data manipulation operation not legal on this view -- … but this one ends in a ORA-01732: data manipulation operation not legal on this view error:
update (
select id
from tq84_A
order by txt
)
set id = 1000 + id
where
rownum <= 5;