Hi
I wonder if I could get some help on this query…….
Oracle version is:
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 9 13:14:30 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Wed Apr 09 2025 13:14:26 +01:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
I have a script which is just a series of sql updates to the database (30-40 sql statements ) on different items in the db with a 'commit' at the end.
Once the sql statements have been committed how can i rollback all those transactions if i needed to at a different time ie after the changes have been committed ie all the same transactions that were executed and committed as part of the script.
example of what would be in the script…
--G23/C0359
UPDATE LPU
SET USAGE = 24.440
WHERE LPU_OL = 1
AND LPU_ID = 178695;
--G23/C0611
UPDATE LPU
SET USAGE = 96.267
WHERE LPU_OL = 3
AND LPU_ID = 7147;
UPDATE FUC
SET USAGE_ON_REMOVE = 418.834
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 127418;
UPDATE FUC
SET USAGE_AT_FIT = 418.834
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 127419;
UPDATE LPU
SET USAGE = 5.4
WHERE LPU_OL = 1
AND LPU_ID = 17545;
…
…
…
commit;
Regards