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; /