Simple AFTER update trigger : After Update Trigger « Trigger « Oracle PL / SQL






Simple AFTER update trigger


SQL> create table t( x int,
  2                  constraint t_pk primary key(x)
  3  );

Table created.

SQL>
SQL>
SQL> create trigger t_trigger AFTER update on T for each row
  2  begin
  3       dbms_output.put_line( 'Updated x=' || :old.x || ' to x=' || :new.x );
  4  end;
  5  /

Trigger created.

SQL>
SQL> insert into t values ( 1 );

1 row created.

SQL> insert into t values ( 2 );

1 row created.

SQL>
SQL> set serveroutput on
SQL>
SQL> update t set x = 2;
Updated x=1 to x=2
Updated x=2 to x=2
update t set x = 2
*
ERROR at line 1:
ORA-00001: unique constraint (JAVA2S.T_PK) violated


SQL>
SQL> update t set x = x+1;
Updated x=1 to x=2
Updated x=2 to x=3

2 rows updated.

SQL>
SQL>
SQL> drop table t;

Table dropped.

SQL>
SQL>
SQL>

           
       








Related examples in the same category

1.Create an after update trigger