Question: 3. Create a trigger OvrPatient that will guarantee any time the patient cancer type is updated if complication is infection and complication mod is wound

3. Create a trigger OvrPatient that will guarantee any time the patient cancer type is updated if complication is infection and complication mod is wound infection the trigger writes the following message to the output window. \begin{tabular}{l} **ATTENTION*** ATTENTION** \\ PLCO_ID: \\ Cancer Type: \\ Study Year: \\ Complication days: \\ \hline \end{tabular} Test it with: \[ \begin{array}{l} \text { update OVARIAN_MED_COMP } \\ \text { set CANCTYPE = } 1 \\ \text { where PLCO_ID = 'A-108809-7';/ } \end{array} \] Output should look like: Test it with: \[ \begin{array}{l} \text { update OVARIAN_MED_COMP } \\ \text { set CANCTYPE = 2 } \\ \text { where PLCO_ID = T-121744-8;/ } \end{array} \] Output should look like: Show the program at the first red arrow. Show the output of the trigger at the second red arrow by snipping them. [10]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
