Write a trigger that is fired after an INSERT statement is executed for the STUDENT table. The trigger writes the new student’s ID, user’s name, and system’s date in a table called TRACKING. (Note: You must create the TRACKING table first)

Question

What will be an ideal response?

Answer 1

```
SQL> CREATE TABLE tracking
2 (StudentId CHAR(5),
3 UserName VARCHAR2(15),
4 TransDate DATE);

Table created.

SQL> CREATE OR REPLACE TRIGGER student_ai_trigger
2 AFTER INSERT ON student
3 FOR EACH ROW
4 DECLARE
5 v_studentid student.StudentId%TYPE;
6 BEGIN
7 v_studentid := :NEW.StudentId;
8 INSERT INTO tracking
9 VALUES (v_studentid, USER, SYSDATE);
10 END;
11 /

Trigger created.

SQL> INSERT INTO student VALUES
2 ('00110','Shah', 'Henna', '747 Valley Road', 'Maplewood',
3 'NJ', '07040', 'SP03', '13-JAN-1975', 123, 500, '9739332628')
4 /

1 row created.

SQL> SELECT * FROM tracking;

STUDE USERNAME TRANSDATE
----- --------------- ---------
00110 NSHAH 17-JUL-04
```