mjhjmtu

I want to add a statement just after the text matching the conditions mentioned in a shell script,

Below is my sample File(SQL File) :

begin
AFFECTED_ROWS := 0;

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

DELETE FROM table_name
WHERE condition;

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

MERGE INTO employees e
 USING hr_records h
 ON (e.id = h.emp_id)
 WHEN MATCHED THEN
 UPDATE SET e.address = h.address
 WHEN NOT MATCHED THEN
 INSERT (id, address)
 VALUES (h.emp_id, h.address);
end;

I will take this file and perform below transformation,
Once I see any of below Text in sequence

1: "UPDATE ... SET ...;"
2: "DELETE ... FROM ...;"
3: "INSERT ... INTO ...;"
4: "MERGE ... INTO ... [WHEN MATCHED THEN | WHEN NOT MATCHED] ... [UPDATE|INSERT|DELETE] ... ;"

I need to add 1 extra row just after the semicolon

AFFECTED_ROWS := AFFECTED_ROWS + SQL%ROWCOUNT;

So My new file will look like something below

begin
AFFECTED_ROWS := 0;

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
AFFECTED_ROWS := AFFECTED_ROWS + SQL%ROWCOUNT;

DELETE FROM table_name
WHERE condition;
AFFECTED_ROWS := AFFECTED_ROWS + SQL%ROWCOUNT;

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
AFFECTED_ROWS := AFFECTED_ROWS + SQL%ROWCOUNT;

MERGE INTO employees e
 USING hr_records h
 ON (e.id = h.emp_id)
 WHEN MATCHED THEN
 UPDATE SET e.address = h.address
 WHEN NOT MATCHED THEN
 INSERT (id, address)
 VALUES (h.emp_id, h.address);
AFFECTED_ROWS := AFFECTED_ROWS + SQL%ROWCOUNT;

end;

I tried finding and implementing the approach in the scope of PLSQL but didn't find any generic way possible to get no of rows affected, so I thought
of text parsing but I don't know much about awk or sed.

For now what I was trying to do something like below:

sed '/Patterns Go Here/a AFFECTED_ROWS := AFFECTED_ROWS + SQL%ROWCOUNT;' temp.sql

So pattern may have conditions mentioned above