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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!