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
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