Trigger for a Newbie

From: Black Rook <blackrook_at_darkhorsefan.net>
Date: Thu, 03 Feb 2000 12:47:22 GMT
Message-ID: <s9hk1887er2121_at_corp.supernews.com>

[Quoted] I am attempting to create a trigger that will be part of a package.

What I would like this trigger to do is enter each new students enrolled into the new student table after insert as well as the date_enrolled and who enrolled the student. Can anyone offer help towards a solution?

STUDENT

ID                                       NOT NULL NUMBER
FIRST_NAME                      NOT NULL VARCHAR2(20)
LAST_NAME                       NOT NULL VARCHAR2(20)
MAJOR                               NOT NULL VARCHAR2(20)
DATE_ENROLLED               NOT NULL DATE

NEW_STUDENT
ID                                       NOT NULL NUMBER(10)
FIRST_NAME                      NOT NULL VARCHAR2(20)
LAST_NAME                       NOT NULL VARCHAR2(20)
MAJOR                               NOT NULL VARCHAR2(20)
DATE_ENROLLED               NOT NULL DATE
ENROLLED_BY                   NOT NULL VARCHAR2(20)

Received on Thu Feb 03 2000 - 13:47:22 CET