I am a newbie in PL/SQL and i have a table called ***STUDENT***, and it contains the following columns: **REGNO, NAME, FNAME, DOMICILE, FEES, STATUS**.
what i want to do is when a new record is created and if the student domicile for example `DOMICILE = 'TEXAS'` and `STATUS = 'ACTIVE'` then i want to give 50% Discount in **FEES**.
Here is my code:

```
CREATE OR REPLACE TRIGGER MYTRIGGER
BEFORE INSERT ON STUDENT
FOR EACH ROW
BEGIN
IF :NEW.DOMICILE = 'TEXAS' AND :NEW.STATUS = 'ACTIVE' THEN
UPDATE STUDENT SET FEES = FEES - 0.50 * FEES;
END IF;
END MYTRIGGER;
/

```

the trigger gets created but it does not work properly..
example:

```
SQL> INSERT INTO STUDENT VALUES(1,'MARK','SMITH','TEXAS',5000,'ACTIVE');

1 row created.

SQL> SELECT * FROM STUDENT;

     REGNO NAME                           FNAME                          DOMICILE                          FEES STATUS
---------- ------------------------------ ------------------------------ ------------------------------ ---------- --------------------
         1 MARK                           SMITH                          TEXAS                                5000 ACTIVE

SQL> INSERT INTO STUDENT VALUES(2,'JAMES','FORD','TEXAS',5000,'ACTIVE');

1 row created.

SQL> INSERT INTO STUDENT VALUES(3,'SAM','MILLER','NEW JERSEY',5000,'ACTIVE');

1 row created.

SQL> SELECT * FROM STUDENT;

     REGNO NAME                           FNAME                          DOMICILE                          FEES STATUS
---------- ------------------------------ ------------------------------ ------------------------------ ---------- --------------------
         1 MARK                           SMITH                          TEXAS                                2500 ACTIVE
         2 JAMES                          FORD                           TEXAS                                5000 ACTIVE
         3 SAM                            MILLER                         NEW JERSEY                           5000 ACTIVE

SQL>

```

any suggestions?