Hi
I am using a 12c database and will need to run a script at site on the client database. The script will be kicked off by a batch file to run the .sql script.
It will consist of a series of sql statements to delete/update records relating to an item . Each series of statements exist such as below where for instance for G02/35703 record there are a series of updates and a delete to be done. Then for the G12/30900 record another series of updates and delete occur relating to that record.
If when it comes to executing the script on the day the user decides that everything relating to say G12/30900 shoudnt be executed how can I rewrite or exclude the series of statements under that record whether in the batch file or the sql script? They can be arranged however I need to but under for each record ie G02/35703 or G12/30900 I need to have a way to exclude a series of sql statement relating to them?.
Am trying to avoid someone having to edit the script to simply comment out the section not required
Regards
-- G02/35703
-- 1ST FIT
UPDATE FITMENT_USAGE_CHILD
SET usage_at_fit = 0,
USAGE_ON_REMOVAL = 207
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 157234
AND LI_PARAMETER = 'CYCLE';
-- 2ND FIT
UPDATE FIT_USAGE_CHILD
SET USAGE_AT_FIT = 207,
USAGE_ON_REMOVAL = null
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 153923
AND LI_PARAMETER = 'CYCLE';
UPDATE FIT_USAGE_CHILD
SET USAGE_AT_FIT = 46,
USAGE_ON_REMOVAL = null
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 153923
AND LI_PARAMETER = 'HOURS';
UPDATE LPU
SET USAGE = 862.8
WHERE LPU_OL = 1
AND LPU_ID = 140210;
DELETE FROM LPU
WHERE LPU_OL = 1
AND LPU_ID = 140211;
-- G12/30900
-- 1ST FIT
UPDATE FITMENT_USAGE_CHILD
SET usage_at_fit = 0,
USAGE_ON_REMOVAL = 100
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 157204
AND LI_PARAMETER = 'CYCLE';
-- 2ND FIT
UPDATE FIT_USAGE_CHILD
SET USAGE_AT_FIT = 207,
USAGE_ON_REMOVAL = null
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 1530
AND LI_PARAMETER = 'CYCLE';
UPDATE FIT_USAGE_CHILD
SET USAGE_AT_FIT = 46,
USAGE_ON_REMOVAL = null
WHERE FITMENT_HISTORY_OL = 1
AND FITMENT_HISTORY_ID = 153900
AND LI_PARAMETER = 'HOURS';
UPDATE LPU
SET USAGE = 800.8
WHERE LPU_OL = 1
AND LPU_ID = 140211;
DELETE FROM LPU
WHERE LPU_OL = 1
AND LPU_ID = 14000;