求教一个出发器

[neyo123456]

当a表被查入一条数据，这条数据的id字段就自动赋值给这条数据的pid字段

[真的不知道取什么名]

scott@YPCOST> create table test(id number,name varchar2(20));

Table created.

scott@YPCOST> 
scott@YPCOST> create or replace trigger insert_tri
  2  before insert on test
  3  for each row
  4  begin
  5  :new.name:=:new.id;
  6  end;
  7  /

Trigger created.

scott@YPCOST> insert into test(id) values(1);

1 row created.

scott@YPCOST> commit;

Commit complete.

scott@YPCOST> select * from test;

        ID NAME
---------- --------------------
         1 1

[neyo123456]

ok，谢谢啦