SQL> create table mytab (ename varchar2(20));

Table created.

SQL> create table mytab_new (ename varchar2(20));

Table created.

SQL> create or replace trigger tai_mytab
  2    after insert on mytab
  3    for each row
  4  begin
  5    insert into mytab_new (ename) values (:new.ename);
  6  end;
  7  /

Trigger created.

SQL> insert into mytab (ename) values ('Littlefoot');

1 row created.

SQL> insert into mytab (ename) values ('OraFAQ');

1 row created.

SQL> select * from mytab;

ENAME
--------------------
Littlefoot
OraFAQ

SQL> select * from mytab_new;

ENAME
--------------------
Littlefoot
OraFAQ

SQL>

SQL> set colsep ";"
SQL> set head off
SQL> spool depts.txt
SQL> select * From dept;

        10;ACCOUNTING    ;NEW YORK
        20;RESEARCH      ;DALLAS
        30;SALES         ;CHICAGO
        40;OPERATIONS    ;BOSTON

SQL> spool off;