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; /
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter