Create or replace table logline (Mno number (7), Mtext1 varchar2 (150), Mtext2 varchar2 (50), Mtext3 char (3), Mdate date); TASK 2 Write a database trigger that fires after a DML statement on the table ENEW. The trigger should check whether the department number (deptno) or the salary (sal) have been changed. If there has been a change, insert the old and the new values into the LOGLINE table you created earlier. Use the mtext1 column.

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prio…