利用trigger实现oracle记录插入时为时间戳赋值

create table timestamp_test(a timestamp ,b varchar2(10));
create or replace trigger ins_timestamp
before insert
on timestamp_test
for each row
begin
 :new.a := sysdate;
end;
/

insert into timestamp_test (b) values ('Hello');

select * from timestamp_test;
A
---------------------------------------------------------------------------
B
----------
15-JUL-05 11.30.52.000000 AM
Hello