In PL SQL, Create a trigger on employees that will not allow employees to update salary for Accountants. Executes the trigger body before the triggering DML event on a table.

As result of your trigger the following message should be displayed “ You are not allowed to update accountants salary”

Hint: Use when clause

Clunker motors inc. is recalling all vehicles in its extravagant line from model years 1999—2002 as well as all vehicles in its guzzler line from model years 2004—2007. a boolean variable named recalled has been declared. given a variable modelyear and a string modelname, write a statement that assigns true to recalled if the values of modelyear and modelname match the recall details and assigns false otherwise.