SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update column using Order by

Rohith369-OracleSep 29 2022

Hi - I have been trying to update a column based on existing column using ORDER BY ID and UPDATE
but when I execute below code, I receive error as "ORA-01732: data manipulation operation not legal on this view"

UPDATE (SELECT * FROM SL_RESULTS Order by ID)  
SET START_DATE_NEW = add_months( start_date, 3 * mod( rownum, 4 ));

Is there a way I can Order the table by ID first and then update the column ?

This post has been answered by BluShadow on Sep 29 2022

Jump to Answer

Added on Sep 29 2022

#plsql, #sql

2 comments

2,805 views

1 mention