SQL & PL/SQL

HI,

i have global temporary table

CREATE GLOBAL TEMPORARY TABLE register(

  register_id NUMBER primary key,

  create_time date

) ON COMMIT DELETE ROWS;

i have to write a trigger on this table whenever an insert is done,

create or replace trigger tri_register

   before insert on REGISTER

   for each row

begin

    :new create_Date:=sysdate;

end;

/

can this trigger work on this register table?

Thanks,