Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger - help!!!

Trigger - help!!!

From: David Jeyathilak <david_at_ionideainteractive.com>
Date: 16 Nov 2001 05:00:40 -0800
Message-ID: <3e9566e2.0111160500.442d8b56@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US