Question: Given the structure of the EMPLOYEE table below. CREATE TABLE EMPLOYEE ( ); EMP ID number (10) primary key, FIRST NAME varchar2(50), LAST NAME
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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Here is the code for the rowlevel before insert trigger name... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help