Re: Basic trigger question

"J.Patrick" <pat_at_mindwrap.com> wrote in message news:73e908ac.0109271252.35c9836a_at_posting.google.com...
> pat_at_mindwrap.com (J.Patrick) wrote in message
news:<73e908ac.0109270632.41131161_at_posting.google.com>...
> > Can you have a trigger that performs a function on the same table that
> > initiates the trigger. For example a trigger created like this:
> >
> >
> > create or replace trigger [trigger name]
> > after insert or update on table_abc
> > for each row
> > begin
> > update table_abc set odcomments = concat(column1, column2, column3);
> > end;
> >
> >
> > If not... does anyone have any suggestions to do what seems like a
simple action?
> >
> > Thanks very much.
> >
> >
> > Pat
>
> Guess I should show the actual trigger I am working with rather that just
examples.
>
> This what I have. I know it's probably way off.
>
> create or replace trigger conf2tech
> after insert on techtest
> BEGIN
> update table techtest t
> SET :new.company_name =
> (SELECT company_name
> FROM client_config c
> WHERE a.serial_num = c.serial_num )
> END;
> /

create or replace trigger conf2tech
 after insert on techtest
 BEGIN

      SELECT company_name
      into :new.company_name
      FROM client_config c
      WHERE c.serial_num = :new.serial_num; -- as the a alias occurs nowhere

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 27 2001 - 16:19:44 CDT