不需要trigger的。 直接再sql语句中添加即可如:update a set a.name='12'||'name' where a.name is not null; commit;
可以,直接select name + 12 from b。
create table test(id number, name varchar2(20)); SQL> create or replace trigger trtest 2 before insert or update on test 3 for each row 4 begin 5 select '12' || :new.name into :new.name from dual; 6 end; 7 /Trigger createdSQL> insert into test values(1, 'TT');1 row insertedSQL> select * from test; ID NAME ---------- -------------------- 1 12TTSQL>
直接再sql语句中添加即可如:update a set a.name='12'||'name' where a.name is not null;
commit;
SQL> create or replace trigger trtest
2 before insert or update on test
3 for each row
4 begin
5 select '12' || :new.name into :new.name from dual;
6 end;
7 /Trigger createdSQL> insert into test values(1, 'TT');1 row insertedSQL> select * from test; ID NAME
---------- --------------------
1 12TTSQL>