Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Trigger - help!!!
Hi,
create table1(
qty number(10),
id varchar2(5)
);
I call the following trigger on update/insert on table1. How do I get the value of 'id' which was just inserted in table1?
create or replace trigger trgA
after update or insert on table1
declare
cursor c1 is select qty from table1 where id='value of id which was
just inserted';
begin
end;
Received on Fri Nov 16 2001 - 07:00:40 CST