行级触发器

create table words (word varchar2(10))

create or replace trigger trim_word 

before insert on words 

for each row 

begin 

  :new.word := trim(:new.word); 

end;

 

insert into words (word) values (' Hello ')

insert into words (word) values ('  World  ')

select word, length(word) from words

 

 

不创建触发器测试

create table words1 (word varchar2(10))

insert into words1 (word) values (' Hello ')

insert into words1 (word) values ('  World  ')

select word, length(word) from words1;