Use sysdate and user function in a trigger : Create Trigger « Trigger « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Trigger
  3. Create Trigger

Use sysdate and user function in a trigger

    
SQL> CREATE TABLE DEPT(
  2      DEPTNO NUMBER(2),
  3      DNAME VARCHAR2(14),
  4      LOC VARCHAR2(13)
  5  );

Table created.

SQL>
SQL> INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');

1 row created.

SQL> INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS');

1 row created.

SQL> INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO');

1 row created.

SQL> INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');

1 row created.

SQL>
SQL> alter table dept add(last_update date,last_user varchar2(30));

Table altered.

SQL>
SQL> CREATE OR REPLACE TRIGGER deptBR
  2       before update or insert
  3       ON dept
  4       FOR EACH ROW
  5       DECLARE
  6  begin
  7          :new.last_update := sysdate;
  8          :new.last_user := user;
  9  end;
 10  /

Trigger created.

SQL>
SQL> drop table dept;

Table dropped.








Related examples in the same category

1.create or replace trigger
2.Oracle's syntax for creating a trigger based on two tables
3.Trigger on each row
4.Use Sequence in a trigger
5.Empty trigger(before insert or update or delete)
6.Create tigger on wrapper table
7.This trigger sends messages over a pipe to record inserts into myStudent.
8.Cascade inserts into myStudent into session and lecturer.
9.Trigger is autonomous and hence the changes will be logged even if the original transaction rolls back.
10.Trigger Which Modifies a Mutating Table
11.Creating a Trigger with cursor inside
12.Autonumbering Trigger
13.Use RAISE_APPLICATION_ERROR in a trigger
14.Show errors for a trigger
15.Submit job from a trigger