I am using SQL developer and want to update different rows with different vlues using one unique ID and different rows id For example as mentioned below :
update repayment_schedule set fromdate ='03-SEP-22', duedate='03-OCT-22' where loan_id in '22'
AND installment in '2'
update m_loan_repayment_schedule set fromdate ='03-OCT-22', duedate='03-NOV-22' where loan_id in '22'
AND installment in '3'
update repayment_schedule set fromdate ='03-NOV-22', duedate='03-DEC-22' where loan_id in '22'
AND installment in '4'
How can i use only single query to update the rows with different values.