We are running liquibase version 3.5 with Oracle. We are unable to perform rollbacks in liquibase ,against multiple update/insert operation in a single changesets.
Scenario is that we have list of multiple updates DMLs in a change-set that will update different tables when running liquibase command. But we did not yet conclude how to Perform Rollback in simple way.
Do we have to write a rollback query for each update command. If yes that’s mean if we have 100 updates so we have to write 100 Rollback queries against each Update statement.
Is there any solution or use case that we can follow and rollback using a single statement.
e.g. update Table set xyz='someValue' where ID=102;
so i want a rollback, please suggest i have 100 of queries like above