Given the structure of the EMPLOYEE table below. CREATE TABLE EMPLOYEE ( ); EMP ID number...

 

Transcribed Image Text:

Given the structure of the EMPLOYEE table below. CREATE TABLE EMPLOYEE ( ); EMP ID number (10) primary key, FIRST NAME varchar2(50), LAST NAME varchar2(50), DATE OF BIRTH date, DATE OF DEATH date, CREATED BY varchar2 (20), CREATED DATE date Write a row-level before insert trigger named TRG EMP_AGE_CHECK to restrict users from adding a new row into the EMPLOYEE table if the employee is below 18 years of age. Given the structure of the EMPLOYEE table below. CREATE TABLE EMPLOYEE ( ); EMP ID number (10) primary key, FIRST NAME varchar2(50), LAST NAME varchar2(50), DATE OF BIRTH date, DATE OF DEATH date, CREATED BY varchar2 (20), CREATED DATE date Write a row-level before insert trigger named TRG EMP_AGE_CHECK to restrict users from adding a new row into the EMPLOYEE table if the employee is below 18 years of age.

Answer rating: 100% (QA)

Here is the code for the rowlevel before insert trigger name... View the full answer