Re: Basic trigger question

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 )