All Questions
2
questions
2
votes
1
answer
541
views
Oracle Update Query On Select Query | Error ORA-01733 Virtual Column Not Allowed Here
update(
select id, word, status
case when sm = 1 and status = 'Renew'
then coalesce(lgst, 'Add')
else status
end as status1,
...
0
votes
1
answer
110
views
Convert Select Oracle Query To Updte for specific scenario
we are using Oracle v12+
we have a situation where we need to update status column to previous value whenever we have first RENEWAL for every code (it is functional ID and has many rows against one ...