First create a table called Person$($Don$$t insert any values into created table$)$

$$ Write code for Trigger and run the trigger program

$$ Insert values into the created table after successful completion of trigger program and see the

trigger

output.

$($a$)$ CREATE TABLE PERSON$1($ID INTEGER, NAME VARCHAR$2(30),$ DOB DATE, PRIMARY KEY$($ID$))$;

$($b$)$

CREATE OR REPLACE TRIGGER PERSON$\_$INSERT$\_$BEFORE

BEFORE INSERT ON PERSON$1$

FOR EACH ROW

BEGIN

DBMS$\_$OUTPUT.PUT$\_$LINE$($BEFORE INSERT OF$||$:NEW.NAME$)$;

END; $/$

$($c$)$ INSERT INTO PERSON$1$ VALUES$(1,$JOHN DOE$,$SYSDATE$)$;