assessment-actions-trigger

create or replace trigger "ASSESSMENT_RESULTS_T1"
AFTER
insert on "ASSESSMENT_RESULTS"
for each row
begin
INSERT INTO ACTIONS 
(REPORT_ID,QUESTION,SCORE,MIN_SCORE,MAX_SCORE,FINAL_SCORE,COMMENTS)
SELECT REPORT_ID,QUESTION_ID,SCORE,MIN_SCORE,MAX_SCORE,(SCORE*100/MAX_SCORE) AS FINAL_SCORE,COMMENTS 
FROM (select a.*,max(rowid) over () as max_pk from assessment_results a)
where rowid = max_pk;
end;
/