Re: Trigger - help!!!

consider:

create sequence s start with 1;

create trigger t before update on my_table for each row
begin
  if :new.id is null then select s.nextval into :new.id from dual; end if; end;

insert into my_table values (...............) RETURNING ID into my_id_variable;

"David Jeyathilak" <david_at_ionideainteractive.com> wrote in message news:3e9566e2.0111160500.442d8b56_at_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 - 13:57:36 CST