Re: Basic trigger question

try this

 create or replace trigger [trigger name]  after insert or update on table_abc
 for each row
 begin

     :new.odcomments := :new.column1||:new.column2||:new.column3; end;

Marc

"J.Patrick" <pat_at_mindwrap.com> 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
Received on Thu Sep 27 2001 - 10:12:11 CDT