Restrictions on Triggers on UPDATE Operations You cannot specify UPDATE OF for an INSTEAD OF trigger. Oracle fires INSTEAD OF triggers whenever an UPDATE changes a value in any column of the view. You cannot specify a nested table or LOB column in the UPDATE OF clause.
可以的。 create table a_blob ( aid number(10), ablob blob );create table b_blob ( bid number(10), bblob blob );create or replace trigger a_tri after insert or update on a_blob for each row begin insert into b_blob values(:new.aid,:new.ablob); end; /
确定吗?我看PL/SQL程序设计上说"LOB数据可以适用触发器进行操纵"呀?
LOB不就是包括BLOB在内的四种类型吗?
You cannot specify UPDATE OF for an INSTEAD OF trigger. Oracle fires INSTEAD OF triggers whenever an UPDATE changes a value in any column of the view. You cannot specify a nested table or LOB column in the UPDATE OF clause.
create table a_blob
( aid number(10),
ablob blob
);create table b_blob
( bid number(10),
bblob blob
);create or replace trigger a_tri
after insert or update on a_blob
for each row
begin
insert into b_blob values(:new.aid,:new.ablob);
end;
/
我再看看有无低级错误.
LOB类型同一般数据类型的操作是一样的,考!!!