~
"afiedt.buf" 8 lines, 145 characters

  1  create or replace trigger
  2  tri1
  3  before update on dept
  4  for each row
  5  begin
  6  insert into dept_back values (:old.deptno,:old.dname,:old.loc);
  7* end;
SQL> /

Trigger created.

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL> select * from dept_back;

no rows selected

SQL> update dept set dname='new' where deptno=10;

1 row updated.

SQL> update dept set loc='boston';

4 rows updated.

SQL> select * from dept_back;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        10 new            NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 new            boston
        20 RESEARCH       boston
        30 SALES          boston
        40 OPERATIONS     boston